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
- 9370 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 |
Tell me what are the advantages of using stored procedures?
Which autogrowth database setting is good?
What type of locking occurs during the snapshot generation? : sql server replication
Delete duplicate rows from a table without primary key by using a single query Table Employee empname salary A 200 B 300 A 200 C 400 D 500 D 500 Output should be A 200 B 300 C 400 D 500
How you trouble shoot when any job fails
How do I find the sql server instance name?
What do we have to check in database testing?
How to declare and use cursor variables?
What is after dml trigger?
what is the signification difference of this bit data type between sql 6.5 and later version sql server?
What are the High-Availability solutions in SQL Server and differentiate them briefly?
What is split brain scenario in DB mirroring?
-
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)
