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

What is sqlca in powerbuilder?

0 Answers  

---

Which function is used to return remainder in a division operator in sql?

0 Answers  

---

display records from 5 to 9 using rowid or rownum

5 Answers   Agile Software,

---

What do you understand by case manipulation functions?

0 Answers  

---

What are different joins used in sql?

0 Answers  

---

---

1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...

0 Answers   Satyam,

---

What is not in sql?

0 Answers  

---

Explain the uses of a database trigger?

0 Answers  

---

How to convert ms-excel file to oracle table?

2 Answers  

---

What are the blocks in stored procedure?

6 Answers   Microsoft,

---

Does sql between include endpoints?

0 Answers  

---

What is clustered, non-clustured and unique index. How many indexes can be created on a table ?

3 Answers   TCS,

---