What are the type of Indexes? which one is best, why?
- 6 Answers
- 8546 Views
- I also Faced
- E-Mail Answers
Answer Posted / a.ganesh
not only two type, more type of indexes there
such as Clustered Index with Primary And Index with Uniqu
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do you trace the traffic hitting a sql server?
How does stuff differ from the replace function?
What is inline table-value user-defined function?
What is the difference between a primary key and a unique key? Are they the same?
What is the difference between composite index and covering index?
What are constraints in microsoft sql server?
Explain throw statement in sql server 2008?
Do you know clustered and non-clustered index?
What is the recommended total size of your memory optimized tables?
Can you insert NULL in unique column?
How to get a list of all tables with "sys.tables" view in ms sql server?
As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?
How do you migrate data from mssql server to azure?
List down some advantages of sql stored procedure?
can you instantiate a com object by using t-sql? : Sql server database administration
