What is clustered and non-clustered indexes?
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 innodb? : Sql dba
Write a sql select query that only returns each name only once from a table?
What is crud stand for?
Can we have two clustered index on a table?
How do I view tables in sql developer?
What is sqlca in db2?
Which one is faster ienumerable or iqueryable?
How many sql are there?
ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..
what is bdb (berkeleydb)? : Sql dba
What is bind reference and how can it be created?
What is column?
What is the example of procedure?
hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews
Why having clause is used in sql?