Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Cluster and Non-cluster index?
- 32 Answers
- 147102 Views
- Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi, I also Faced
- E-Mail Answers
Answer Posted / ghanshyam vishwakarma
CLUSTER:- cluster like a pointer that point to one page to
another and get the final data.
NON CLUSTERED INDEX:
Non clustered index will be created automatically when u
create unique key on a column. A table can have no.of
unique keys, so we can create no.of non clustered indexes
per table.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
System requirements for sql server 2005 express edition?
Tell me what is sql profiler?
Can we do dml on views?
Difference between Sql server reporting services and Crystal reports?
Explain what is row_number function?
Does a full backup include transaction log?
Tell me what are cursors and when they are useful?
Can we use trigger new in before insert?
what is new philosophy for database devises for sql server 7.0? : Sql server database administration
What is temporary table in sql server? Why we use temp table?
State a few properties of relational databases?
Tell about MOM Tool(Microsoft Operator Manager)?
ow to bring suspect mode datbase online from scratch
How do I open port 1433?
What is blocking?
