Interested to Buy Any Domain ? << Click Here >> for more details...
When do you create cluster and noncluster index?
- 5 Answers
- 10087 Views
- Satyam, I also Faced
- E-Mail Answers
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
How to enforce security in sql server? : sql server security
What are some examples of schemas?
How to insert and update data into a table with "insert" and "update" statements?
What is the difference between DataRow.Delete() and DataRow.Remove()?
Explain Capacity planning to create a database? and how to monitor it?
How to write a query with a full outer join in ms sql server?
Explain the difference between function and stored procedure?
How to connect php with different port numbers?
How can I get data from a database on another server?
How to create median function?
what does the automatic recovery do? : Sql server administration
What is advantage data architect?
What is a mixed extent?
How to create a dml trigger using create trigger statements?
What is a result set object returned by mssql_query()?
