Not sure if it is appropriate to place my question in here
1.when mssql use heap file to store data and when use direct file?
2.what does index file depend on to group in mssql?
thanks in advance!
i am not sure i understand the question correctly or not.
SQL Server stored the data in table in the form of rows and columns not in files. Tables which do not have clustered index is called heap. So the answer to your first question may be, when you create a table in sql server if you add a primary key by default clustred index is created and the data stored in the table which have CI is in a sorted order.
Second question is not clear to me...
Madhu
|||DBMS need to first group on index file in order to optimize search
How does MSSQL depend on to group index?
No comments:
Post a Comment