Interested to Buy Any Domain ? << Click Here >> for more details...
diffrence between Cluster Index and non Cluster Index
- 3 Answers
- 6327 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / naren
Only one clustered Index and 249 non clustered index
data is Physically order in CI and
The physical order of the rows is not same as the index order in NCI.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
How to list all field names in the result set using mssql_field_name()?
What is a data source file?
How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
What does <> symbol mean?
How do I make a resultset scrollable?
What is 2nf in normalization?
What is transaction server explicit transaction?
Name few endpoints exposed by ssrs 2012?
How do we know if any query is retrieving a large amount of data or very little data?
How to modify existing triggers using "alter trigger"?
What is data set in report?
What is an active database?
Explain different types of collation sensitivity?
What is meant by Active-Passive and Active-Active clustering setup?
How to use group functions in the select clause in ms sql server?
