Difference between Cluster and Non-cluster index?
- 32 Answers
- 138367 Views
- Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi, I also Faced
- E-Mail Answers
Answer Posted / p.karthick
clustered index is physically stored
a table can have 1 clustered index
non clustered index is logically stored
a table can have 249 non clustred index
| Is This Answer Correct ? | 193 Yes | 46 No |
Post New Answer View All Answers
Give a example to search fr a string in all stored procedure in sql server.
How to apply filtering criteria at group level with the having clause in ms sql server?
Do you know what are different types of replication in sql server?
What is the difference between stored procedure and functions?
Explain how does the report manager work in ssrs?
What are the commands used in DCL?
Explain indexed views and partitioned view with their syntax.
Can you change the data type of a column in a table after the table has been created? If so, which command would you use?
How to create nested stored procedure?
How to see existing views in ms sql server?
How to run sql server 2005 books online on your local system?
What are the types of sql server?
how many bits ip address consist of? : Sql server database administration
Explain how to use linked server?
How each E-R model constructs can be mapped to the relational model?
