Interested to Buy Any Domain ? << Click Here >> for more details...
How many index can be created for single table
- 4 Answers
- 18522 Views
- CarrizalSoft Technologies, Verizon, I also Faced
- E-Mail Answers
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
What is a hint?
Explain acid?
Some queries related to SQL
What is a Join and explain its types?
What is sql server programming?
What is a table called, if it has neither cluster nor non-cluster index? What is it used for?
What is coalesce and check constraint in sql server?
What is a with(nolock)?
What is the maximum number of index per table?
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
Which are the two editions in which SQL Azure database available?
What is the purpose of object explorer and its features? : sql server management studio
what are acid properties? : Sql server database administration
what is a mixed extent? : Sql server administration
What are indexes in ms sql server?
