Interested to Buy Any Domain ? << Click Here >> for more details...
What is clustered and non-clustered indexes?
- 4 Answers
- 14213 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 are the types of variables use in pl sql?
How do you take the union of two tables in sql?
What is on delete set null?
What is ttitle and btitle?
What is difference between db2 and sql?
What is $$ in sql?
What is lookup table in sql?
How do you optimize a stored procedure in sql?
how to select first 5 records from a table? : Sql dba
differentiate between float and double. : Sql dba
what are enums used for in mysql? : Sql dba
How do I filter in sql profiler?
what is self join and what is the requirement of self join? : Sql dba
How many sql databases can you have on one server?
How do you identify a primary key?
