adspace


What is the maximum number of index per table?

Answer Posted / Mayank Singh

"The maximum number of indexes per table in SQL Server depends on the edition and the storage engine used. For example, in SQL Server Express (a free version), the maximum limit is 999 indexes. In higher-end editions like Standard, Enterprise, or Developer, the limit can be up to 2499."

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is acid mean in sql server?

1247


How to convert numeric expression data types using the cast() function?

1151


Where can you add custom error messages to sql server?

1215


What is a coalesce function?

1285


How do I create a trace in sql server?

1121


Explain “row_number()” in sql server with an example?

1080


When should you use an instead of trigger?

1054


What is the difference between for xml raw and for xml auto?

1119


What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1300


How to connect php with different port numbers?

1191


What are the kinds of subquery?

1109


How do I start sql server 2017?

1017


What is an indexed view?

1023


How do I find query history in sql server?

1026


What are the different subsets of sql?

1655