Answer Posted / manisha
cluster index sorts the data ,so its affects the physical
arragement,while non clustered does not sorts the data.
a table can have max of 1 clustered index but can have upto
249 non clustered index.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is the difference between migration and upgradation in sql server?
How to define the name and server for a new dsn?
Why do we use functions?
What is the current limitation of the size of SQL Azure DB?
What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration
if no size is defined while creating the database, what size will the database have? : Sql server administration
What is a ddl statement?
What is code near application topology?
What are the differences between user defined functions and stored procedures?
What is a db view?
How do we Backup SQL Azure Data?
What is service broker? : sql server database administration
What does the not null constraint do?
whats new about truncate in sql server 2008?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?