When do you create cluster and noncluster index?
Answer Posted / nandkumar karlekar
Create the Clustred index when your data are divided into
some countable infinite limited sets which helps to retrive
the set of date from continus data pages from h/d.
because the clustred index stores data physically.
we can create only one clustred index for a table.
reaming searching field can be included in to the non
clust.. index
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what are database files and filegroups? : Sql server database administration
Find first and last day of current month in sql server
What is the size of transaction log file?
What are the properties of the transactions?
How to create “dependant” parameter “make, model, year”
What Is Rdbms?
How many columns can exist together per table?
Detail about the hardware which is supported by SQL server?
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
What is the filtered index?
What are various aggregate functions that are available?
Explain the relational database management system (rdbms)?
What are xml indexes?
Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?
You want to implement the many-to-many relationship while designing tables. How would you do it?