How many Indexes we can create in a Table
Friends,
This is becoming a Frequently Asked Question in SQL Server Interviews now a days.
How many Indexes we can create in a Table ?
@SumanJha
Friends,
This is becoming a Frequently Asked Question in SQL Server Interviews now a days.
How many Indexes we can create in a Table ?
Object
|
SQL Server 7
|
SQL Server 2000
|
SQL Server 2005
|
SQL Server 2008
|
SQL Server 2012
|
Clustered Index
|
1
|
1
|
1
|
1
|
1
|
Non-Clustered Index
|
249
|
249
|
249
|
999
|
999
|
Total
|
250
|
250
|
250
|
1000
|
1000
|
Comments
Post a Comment
Plz dont forget to like Facebook Page..
https://www.facebook.com/pages/Sql-DBAcoin/523110684456757