The maximum number of indexes per table in SQL Server 2019 is 999. However,

What will be the maximum number of index per table?

Question Posted / Meenakshi Dayal

Answer Posted / Meenakshi Dayal

The maximum number of indexes per table in SQL Server 2019 is 999. However, this limit can be increased using ALTER DATABASE.

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Disadvantages of the indexes?

1215

Why we use the openxml clause?

1063

How do I create a trace in sql server?

1109

What is clustered index

1080

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

1041

What is standby servers? Explain types of standby servers.

1067

What is acid mean in sql server?

1229

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

1021

What is sql or structured query language?

1211

How can you append an identity column to a temporary table?

1062

What is a coalesce function?

1274

What are different types of constraints?

989

Can sql servers link to other servers like oracle?

905

How to remove duplicate rows from table except one?

1077

How to rebuild the master database?

1151