in Technology by
What will be the maximum number of index per table?

1 Answer

0 votes
by

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
    The maximum number of slides per row in slide sorter view can be Select the correct answer from above options...
asked Dec 15, 2021 in Education by JackTerrance
0 votes
    how many maximum worksheet are available per Calc spreadsheet documents . Select the correct answer from above options...
asked Dec 14, 2021 in Education by JackTerrance
0 votes
    5.What is the maximum number of columns in a table in the world a.43 b.63.c53 Select the correct answer from above options...
asked Dec 25, 2021 in Education by JackTerrance
0 votes
    which of the following tab should be used to add and delete element such as chapter number hyperlink etc a) ... style d) background Select the correct answer from above options...
asked Nov 27, 2021 in Education by JackTerrance
0 votes
    What is the optimum number of concurrent_reads per processor core ? (1)8 (2)1 (3)5 (4)4...
asked May 6, 2021 in Technology by JackTerrance
0 votes
    What is the optimum number of concurrent_reads per processor core ? (1)8 (2)1 (3)5 (4)4...
asked Apr 17, 2021 in Technology by JackTerrance
0 votes
    How we can control the number of records display per page in Oracle Reports?...
asked Nov 22, 2020 in Technology by JackTerrance
0 votes
    The _________ is a necessary index in a long document * a.Template b.Table of content c.style d.mail merge Select the correct answer from above options...
asked Dec 15, 2021 in Education by JackTerrance
0 votes
    __________ is a contiguous group of blocks allocated for use as part of a table, index, and so forth ... , Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
    The refractive index of water will be (a) 1 (b) 2.66 (c) 5 (d) 1.33 ... electromagnetic theory proposed by,electromagnetic theory engineering physics,electromagnetic theory nptel...
asked Nov 6, 2021 in Education by JackTerrance
0 votes
    In a _______ clustering index, the index record contains the search-key value and a pointer to the first ... , Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
    The maximum number of binary trees that can be formed with three unlabeled nodes is: Select the correct answer from above options...
asked Dec 20, 2021 in Education by JackTerrance
...