Interested to Buy Any Domain ? << Click Here >> for more details...
How many index can be created for single table
- 4 Answers
- 18677 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 “begin trans”, “commit tran”, “rollback tran” and “savetran”?
How to get a list of columns using the "sp_help" stored procedure in ms sql server?
What is data source in connection string?
What are the differences between decimal and float in ms sql server?
Can another user execute your local temporary stored procedures?
Explain what are commit and rollback in sql?
What are database states in ms sql server?
Do you know what is a linked server in sql server?
How can we rewrite sub-queries into simple select statements or with joins?
What is data compression?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
Explain what is the difference between union and union all?
What is store procedure? How do they work?
How extra digits are handled with numeric data type literals?
How does the report manager work in SSRS?
