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
How to create a local temporary stored procedure?
Is null in sql server?
What is the web service used for reporting services?
Explain about thread and memory management process of SQL?
What is a matrix in ssrs?
How to transfer an existing table from one schema to another schema in ms sql server?
Explain nested trigger in sql?
What are transactions in sql?
What is microsoft sql server?
What are the differences between char and varchar in ms sql server?
Explain what is scheduled job and how to create it?
What is trigger explain with program?
Do you know what is a trace frag? Where do we use it?
How to update multiple rows with one update statement in ms sql server?
What are the differences between substr and charindex in sql server.
