What will be the maximum number of index per table?

Question Posted / dalveer singh

What will be the maximum number of index per table?..

Answer / 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

More SQL Server Interview Questions

What is the difference between a unique key and primary key?

Determine when to use stored procedure to complete sql server tasks?

How to download and install the scaled-down database adventureworkslt?

What are a database and a data warehouse?

Does sql server use t sql?

What is default port number for sql server 2000?

How do I find the sql server database version?

How does normalization work?

hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

how to determine the service pack currently installed on sql server? : Sql server database administration

difference between truncate, delete aur drop?

How to replace null values in expressions using isnull()?

For more SQL Server Interview Questions Click Here