Interested to Buy Any Domain ? << Click Here >> for more details...
When do you create cluster and noncluster index?
- 5 Answers
- 10088 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / jerry joseph
A table can have 1 clustered index and 249 non-clustered indexes
indexes make sorting efficient
generally clustered index is ideal for the Primary Key
non-clustered indexes are ideal for columns which are used
in sorting (the columns in OrderBy)
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
what is a deadlock? : Sql server database administration
What are the types of table?
What are the various editions of sql server 2017 that are available in the market?
What is the use of keyword with encryption. Create a store procedure with encryption?
What is a result set object returned by odbc_exec()?
Explain the steps to create and execute a user-defined function in the sql server?
Which sql server table is used to hold the stored procedure script?
what are the critical issues you have resloved in your company
What is a join in sql?
How will you decide the active and passive nodes?
What is the report builder?
How to provide login information for a new odbc dsn?
What are information schema views?
explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
How to use user defined functions in expressions?
