When do u use clustered index and non-clustered index?
Answer Posted / pradeep
To increase the performance of database we can use clustered Index .It will be in sorted order and it is in the form of B tree structure and it won't accept nulls.
Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Can two tables share the same primary key?
How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?
Explain Geometry datatype in sql server 2008 with example
What is use of @@ spid in sql server?
Are semicolons required at the end of sql statements in sql server 2005?
Give the query of getting last two records from the table in SQL SERVER?
What is 3nf normalization?
How to disable a login name in ms sql server?
Do you know what is replace and stuff function in sql server?
What is the difference between substr and charindex in the sql server?
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?
What is the difference between dropping a database and taking a database offline?
what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration
How to drop an existing schema in ms sql server?
Define constraints and give an example of their use?