in Technology by (55.8k points)
What will be the maximum number of index per table?

1 Answer

0 votes
by (55.8k points)

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.

Related questions

0 votes
asked Dec 12, 2020 in Technology by JackTerrance (1.8m points)
...