0 votes
9 views
What will be the maximum number of index per table?
in Technology by (51.6k points)

1 Answer

0 votes

What will be the maximum number of index per table?

For SQL Server 2008 100 Index can be used as maximum number per table. 1 Clustered Index and 999 Non-clustered indexes per table can be used in SQL Server.

1000 Index can be used as maximum number per table. 1 Clustered Index and 999 Non-clustered indexes per table can be used in SQL Server.

1 Clustered Index and 999 Non-clustered indexes per table can be used in SQL Server.

by (51.6k points)

Related questions

0 votes
1 answer 14 views
0 votes
1 answer 14 views
0 votes
1 answer 25 views
0 votes
1 answer 54 views
0 votes
1 answer 14 views
0 votes
1 answer 84 views
0 votes
1 answer 23 views
0 votes
1 answer 11 views
0 votes
1 answer 14 views
0 votes
1 answer 21 views
...