Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / manisha
cluster index sorts the data ,so its affects the physical
arragement,while non clustered does not sorts the data.
a table can have max of 1 clustered index but can have upto
249 non clustered index.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is the importance of a recovery model?
What are the steps you will take to improve the performance of a poor performing query?
What is the difference between locking and multi-versioning?
What is measure group, measure? : sql server analysis services, ssas
How do you send email on SQL Server?
Can a database be shrunk to 0 bytes, if not, why?
What do you understand by mirroring?
What is open database communication (odbc)?
How to find which stored procedure is currently running in sql server?
Is ssrs support other database except ms sql server?
What is the use of “join” in sql server?
What is the difference between dbcc indexdefrag and dbcc reindex?
How to defragment indexes with alter index ... Reorganize?
What do you understand by physical_only option in dbcc checkdb?
What is the maximum size of a dimension? : sql server analysis services, ssas
