Interested to Buy Any Domain ? << Click Here >> for more details...
What is clustered and non-clustered indexes?
- 4 Answers
- 14089 Views
- Microsoft, I also Faced
- E-Mail Answers
Answer Posted / ganesh sial
both index are stored physically but cluster index is create block of key value which more helps to like join,hash condition,more reliable to parent child relation ship
ex:- deptno is primary key for dept table, its create cluster index,
when write query of join like
select a.empno,a.deptno,b.loc from emp a,dept b where a.deptno=b.deptno
this case the cluster index helps to better perfomance
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the difference between a primary key and a unique key?
what is the different between now() and current_date()? : Sql dba
What is the difference between execution of triggers and stored procedures?
How many types of primary keys are there?
What does the sign mean in sql?
What is the use of <> sql?
What does select top 1 do in sql?
What is ttitle and btitle?
What is foreign key sql?
Does sap use sql?
Can we edit a view in sql?
What is the difference between function, procedure and package in pl/sql?
What is range partitioning?
What is sql key?
how many sql ddl commands are supported by 'mysql'? : Sql dba
