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
Are null values the same as that of zero or a blank space?
What is indexing explain it with an example?
How to copy the tables, schema and views from one sql server to another?
Does transparent data encryption provide encryption when transmitting data across the network?
What are different types of schemas?
What is the use of tempdb? What values does it hold?
on line cluster can we make if yes tell me the procedure
What is check constraint in sql server?
What are the advantages of using stored procedures?
What is the fillfactor concept in indexes?
You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?
Describe how to use the linked server?
What do you understand by hotfixes and patches in sql server?
How to use values from other tables in update statements in ms sql server?
What is the current limitation of the size of SQL Azure DB?