Interested to Buy Any Domain ? << Click Here >> for more details...
What is clustered and non-clustered indexes?
- 4 Answers
- 13914 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
Which normal form is best?
Can we delete column in sql?
When to use inner join and left join?
What is nosql db?
How to run pl sql program in mysql?
What is trigger in flip flop?
What are triggers in sql?
how to decrement dates by 1 in mysql? : Sql dba
What are different types of triggers?
What is the trigger in sql?
What are the usages of sql?
What is view explain with example?
how many sql ddl commands are supported by 'mysql'? : Sql dba
What is normalization in sql?
What is cross join sql?
