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
How can change procedure in sql server?
What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?
whats new about truncate in sql server 2008?
Difference between report and query parameter. Why do we need different type of parameter?
What is user defined stored procedures?
how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration
Can sub report data source be different from that of the parent report?
New concepts of sql server 2005 use in your project.
what is a mixed extent? : Sql server administration
In which files does sql server actually store data?
Distinguish between commit and rollback?
Why we need to use secondry database file? though, we can do same work using primary database file also.
Explain the commands in sql server?
How retrieve field names from the table in SQL through JAVA code?
How to skip remaining statements in a loop block using continue statements?