Answer / arunyadav007

Clustered Index.
Because the leaf level of a clustered index is the actual
data and the data is resorted in case of clustered index.
In case of non-clustered index the leaf level is actually a
pointer to the data in rows. The data is stored in one
place, the index in another, with pointers to the storage
location of the data. The items in the index are stored in
the order of the index key values, but the information in
the table is stored in a different order.

Thanks,

Arun

hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

0 Answers   IntraLogic, Oracle,

---

Why I have to use stored procedures?

0 Answers   Cognizant,

---

Explain time data type in sal server 2008?

0 Answers  

---

How reterive duplicate value in SQL?

6 Answers  

---

What is the difference between a primary key and a unique key? Are they the same?

0 Answers  

---

How to bind a view to the schema of the underlying tables?

0 Answers  

---

What is a bit datatype?

0 Answers  

---

Ms sql server index?

0 Answers  

---

How adventureworkslt tables are related?

0 Answers  

---

Define candidate key, alternate key, composite key.

13 Answers   Infosys, Software India,

---

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

0 Answers   HP,

---

How to provide values to user defined function parameters?

0 Answers  

---