Interested to Buy Any Domain ? << Click Here >> for more details...
What is a table called, if it does not have neither Cluster
nor Non-cluster Index?
- 2 Answers
- 9551 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / debasish nanda
Unindexed table or Heap. Microsoft Press Books and Book on
Line (BOL) refers it as Heap. A heap is a table that does
not have a clustered index and, therefore, the pages are not
linked by pointers. The IAM pages are the only structures
that link the pages in a table together. Unindexed tables
are good for fast storing of data. Many times it is better
to drop all indexes from table and then do bulk of inserts
and to restore those indexes after that.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is named query? : sql server analysis services, ssas
What are the advantages of using cte?
Why use sub query in sql server and list out types of sub queries?
How to get a list of columns in a view using "sys.columns" in ms sql server?
What is the purpose of indexing?
List some major differences between triggers and stored procedures?
what is the difference between group and having give an example with query and sample output
What is the difference between row_number and dense_rank?
Wht is the difference between stored procedure and trigger
What is full outer join in sql server joins?
What are some examples of schemas?
What is the difference between commit and rollback?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
