Answer / thangaprabu.n

Apart From above answer,One table Contain only 1 Cluster
index and 249 Non-Cluster Indexes

Answer / shubhi

There are clustered and nonclustered indexes. A clustered
index is a special type of index that reorders the way
records in the table are physically stored. Therefore table
can have only one clustered index. The leaf nodes of a
clustered index contain the data pages.

A nonclustered index is a special type of index in which
the logical order of the index does not match the physical
stored order of the rows on disk. The leaf node of a
nonclustered index does not consist of the data pages.
Instead, the leaf nodes contain index rows.

Answer / nive

clustered index are physically sorted

Answer / 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

Can u create a primary key with out unique index.

8 Answers  

---

What is the use of pl/sql table?

0 Answers  

---

What is varchar sql?

0 Answers  

---

what is dbms? : Sql dba

0 Answers  

---

Can we debug stored procedure?

0 Answers  

---

what is julian date in oracle

2 Answers  

---

discuss about myisam key cache. : Sql dba

0 Answers  

---

declare v_count number(8,3); v_sal scott.emp.sal%type := '&P_sal'; cursor cur_name is select sal from scott.emp where sal between (v_sal-100) and (v_sal +1000); begin v_count :=nvl(sql%rowcount ,0); if v_count = 0 then dbms_output.put_line('no records are fetch in the given sal range'); else dbms_output.put_line('There is/are '||to_char(v_count)|| ' salaries are selected in the given range '); end if; end; in the above programm .....for any sal range ....always it shows the following message.. no records are fetch in the given sal range please find the mistake and share with me...with thansk and regards..sarao....

3 Answers   Satyam,

---

how many triggers are allowed in mysql table? : Sql dba

0 Answers  

---

What is sql mysql pl sql oracle?

0 Answers  

---

What is the difference between a subquery and a join?

0 Answers  

---

What are all different types of collation sensitivity?

0 Answers  

---