diffrence between Cluster Index and non Cluster Index
Answers were Sorted based on User's Feedback
Answer / naren
Only one clustered Index and 249 non clustered index
data is Physically order in CI and
The physical order of the rows is not same as the index order in NCI.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / kumar.t
Index means to sort the data.
Cluster index is physical order of the data.
Non Cluster index is logical order of the data.
| Is This Answer Correct ? | 2 Yes | 0 No |
The difference is that, Clustered index is unique for any
given table and we can have only one clustered index on a
table. The leaf level of a clustered index is the actual data
and the data is resorted in case of clustered index. Whereas
in case of non-clustered index the leaf level is actually a
pointer to the data in rows so we can have as many non-
clustered indexes as we can on the db.
| Is This Answer Correct ? | 2 Yes | 0 No |
what is the system function to get the current user's user id? : Sql server database administration
Explain powershell included in sql server 2008?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
What is index in an assignment?
What is the basic functions for master, msdb, tempdb databases?
What is the use of “join” in sql server?
What is the difference between varchar and varchar types?
What structure can you implement for the database to speed up table reads?
What happens if you add a new index to large table?
Why I am getting this error when dropping a database in ms sql server?
what kind of lan types do you know? : Sql server database administration
What are the differences between lost updates and uncommitted dependencies?
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)