Interested to Buy Any Domain ? << Click Here >> for more details...
What is the basic difference between clustered and a
non-clustered index?
- 9 Answers
- 38176 Views
- Infogain, I also Faced
- E-Mail Answers
Answer Posted / rajesh
I am explaining you with an example, The Telephone
Directory is a fine example of Clustered Index as data and
index are at the same page, whereas index in the back side
of the book is a fine example of non-clustered index and
non-clustered index is a fast B-tree structure as index
just points to the data page. Also only one clustered index
is possible per table and 249 non-clustered index per table.
| Is This Answer Correct ? | 75 Yes | 10 No |
Post New Answer View All Answers
What is difference in performance between insert top (n) into table and using top with insert?
Explain datetimeoffset data type in sal server 2008?
Explain what is the difference between a local and a global temporary table?
Explain database normalization?
What is a transactions?
How to change the password of a login name in ms sql server?
How many replicas are maintained for each SQL Azure database?
When you use @@error and try-catch?
Explain the concepts and capabilities of sql server?
How network traffic be reduced by using the stored procedure?
What is the difference between count and distinct count?
What do you understand by SQL*Net?
Explain active/passive and active/active cluster configurations?
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?
How much memory that we are using in Logshipping Concept?
