Answer Posted / rajkumar
There can be only 1 Clustered index in a table
where as nonclustered index can be upto 249
Clustered is physical sorted index..
non clustered is logical stored index is faster than
clustered index
thats all i know
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
What is right outer join in sql server joins?
What is default constraint in ms sql server?
What causes index fragmentation?
What is the purpose of forms?
How to count duplicated values in a column in ms sql server?
What is linked report?
What are different types of join?
What is correlated subquery in sql server?
What is read uncmmited?
How to rename an existing column with the "sp_rename" stored procedure in ms sql server?
Why do you need a sql server?
What the different components of Replication and what is their use?
What are advantages of ssrs or why we should use ssrs?
How to create a Master database in SQL server ?
Explain error handling in ssis?