Will a table can create a maximum number of index files? Thank you! ! !

Category: MS-SQL Server -> Foundation Classes Author: lryang Date: 2005-03-28 21:40:41
 
lryang
2005-03-28 21:40:41
Will a table can create a maximum number of index files? Thank you! ! !
xuejun123hf
2005-03-28 22:02:54
index more bad

2,3 Personally, I think you can
zhjyym_javva2
2005-03-28 22:41:18
is subject to restrictions on the number of database objects

Each instance of SQL Server database, the number 32,767 32,767
each database file group number 256 256
months of each database file Number 32,767 32,767
file size (data) 32 TB 32 TB
File Size (log) 4 TB 32 TB
Each data table foreign key table references 253 253
Identifier length (in characters) 128 128
number of instances of each computer n 16
length of the string containing SQL statements (batch size) 65,536 * Network Packet Size 1 65,536 * Network Packet Size 1
number of locks per connection maximum number of locks per server maximum number of locks per server
each SQL Server instance locks 2,147,483,647 (static)
SQL Server 40% of memory (dynamic) 2,147,483,647 (static)
SQL Server 40% of memory (dynamic)
nested stored procedure layer Number 32 32
nested subqueries 32 32
nested triggers layers 32 32
each data table a non-clustered index Number 249 249
SQL Server instance while the number of open objects 4 2,147,483,647 (or available memory) 2,147,483,647 (or available memory)
each database The number of objects 2,147,483,6474 2,147,483,6474
number of parameters for each stored procedure 1,024 1,024
number of each data table REFERENCE 253 253
each data table rows restricted by available storage resources available storage resources by limiting
data tables for each database affected by the number of objects in the database limit the number four by the number of objects in the database limit 4
data sheet for each SELECT statement number 256 256
trigger number for each data table by limiting the number of objects in the database 4 by limiting the number of objects in the database for each data table 4
UNIQUE index number or restrict the number of 249 non-clustered indexes and a clustered index 249 nonclustered indexes and 1 clustered index

jyz130
2005-03-28 23:20:12
2 the total number of attribute columns of the table th power minus 1 . There are three properties are listed in Table, the maximum number of index files is 2 ^ 3-1 = 7.