Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Cluster and Non-cluster index?
- 32 Answers
- 146259 Views
- Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi, I also Faced
- E-Mail Answers
Answer Posted / veerreddy
clustered index is that the order of data in table is always
equal or matches to order of data stored in index.there is
only one(1) clustered index for table.it is usually applied
on primary key column in table.
other hand the non-clustered index is that the order of data
in table is not equal or matches to order of data stored in
index.so they can be applied on non-primary key columns like
unique,foreign key etc.A table can have (249) non-clustered
indexes
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
Is it safe to delete log files?
What is difference between stored procedure and user defined function?
What does the update command do?
What is truncate table?
How to make a column nullable?
If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?
What is user-defined multi-statement table-valued function?
Is the order of columns in the set clause important in ms sql server?
How to rebuild all indexes on a single table?
Do you know what is bit data type and whats the information that can be stored inside a bit column?
What are sql dirty pages?
How to create new table with "create table" statements?
what do you understand by change data capture?
What is the distinction amongst delete and truncate?
in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it
