Interested to Buy Any Domain ? << Click Here >> for more details...
why cluster and non clusterindex are used in sqlserver 2000?
explain with example
- 1 Answers
- 4843 Views
- I also Faced
- E-Mail Answers
Answer Posted / venkat
Index is commonly used for faster data retrieval.We can
have only one Clustered Index and many non-clustered index
in a single table.It is known that there is some
limitations in using indexes.If a column is defined as
primary key,by default column is set to be clustered
index.All other indexes created manually in the same table
were non-clustered index.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is temporary stored procedure?
Can a function call a stored procedure in sql server?
Explain filtered indexes benefits?
Explain the truncate command? : SQL Server Architecture
How can a database be repaired?
What are transactions in sql?
Explain how would you store your query in an SSRS report or a Database server?
What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.
what stored procedure can you use to display the current processes? : Sql server administration
How to return the top 5 rows from a select query in ms sql server?
What is difference between standardization and normalization?
List some major differences between triggers and stored procedures?
what is an extended stored procedure? : Sql server database administration
What is a non-clustered index?
What is the boxing and unboxing concept in .net?
