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
How do you trace the traffic hitting a sql server?
Define outer join in sql server joins?
Can you pass expressions to stored procedure parameters?
How to list all schemas in a database?
Can you explain the disadvantages/limitation of the cursor?
What are user-defined functions (udfs) in sql server?
How do I clean up sql server transaction log?
What is transaction server explicit transaction?
Your table has a large character field there are queries that use this field in their search clause what should you do?
What is scheduled job and how to create it?
Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication
What are different types of database indexes?
What are the advantages of using cte?
How to create hyperlink from returned sql query ?
What is a virtual table in sql?