How many index can be created for single table
Answer Posted / sanjay kumar dinda
Two types of indexes are there in SQL Server
1. Clustered Index
2. Non-Clustered Index
We can create only 1 Clustered index in a table as it re-
orders the data of the table
We can create upto 249 Non-Clustered index in a table...
Is This Answer Correct ? | 17 Yes | 0 No |
Post New Answer View All Answers
We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?
What is difference between table aliases and column aliases? Do they affect performance?
Explain about remote stored procedure?
What is a trace frag?
what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration
How to encrypt data between dialogs?
Explain index in sql server?
Is the order of columns in the set clause important in ms sql server?
Explain different types of collation sensitivity?
What is save transaction and save point?
What are the features of Embedded SQL
How can I change procedure name in sql server?
As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?
Which are new data types introduced in sql server 2008?
What are approximate numeric data types in ms sql server?