Interested to Buy Any Domain ? << Click Here >> for more details...
When do you create cluster and noncluster index?
- 5 Answers
- 10304 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
What do you mean by SQL injection attack?
How to convert binary strings into integers in ms sql server?
We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?
Are resultset updatable?
What are the benefits and tasks of object explorer? : sql server management studio
How to locate and take substrings with charindex() and substring() functions?
Can you insert NULL in unique column?
how will add additional conditions in sql?
What are the advantages dts has over bcp?
What happens when converting big values to integers?
How to write a query with a left outer join in ms sql server?
What are the differences between having and where clause.
Tell me what is the significance of null value and why should we avoid permitting null values?
what is a join and explain different types of joins? : Sql server database administration
Define compound operators?
