Answer / rm thirunavukkarasu

Index is used to Retrive the Information in efficient
manner. And query processor perform reliably.

There are 3 types of Index namely
*Cluster based Index
*Non Cluster based Index
*Noncomposite Index
*Compositive Index
*Unique Index

For more info adt sql plz visit www.thiruna.blog.com

Answer / sandip kumar chaturvedi

index is a data structure that improve the operation on
table.there are two types of index.
1) ordered index.
2) hashed index.
up to 249 clustered indexes per table.

What is the difference between a procedure and a function?

0 Answers  

---

What is sql indexing?

0 Answers  

---

how to insert the data through views? The view is depending upon more than two tables? how to update materalized views?

3 Answers   3i Infotech,

---

What is Overloading of procedures ?

4 Answers   Amdocs,

---

What is the basic form of sql query?

0 Answers  

---

---

which will default fire first  statement level trigger or row level trigger

2 Answers   Cap Gemini, Data Vision,

---

suppose u hav 1 book with set...page 1-100 n 101 -200 now print page from 2-100 n 102 -200... how we will do..?

6 Answers  

---

What are different types of queries in sql?

0 Answers  

---

what are the types of join and explain each? : Sql dba

0 Answers  

---

what is a scheduled jobs or what is a scheduled tasks? : Sql dba

0 Answers  

---

oracle is compiler or interpretter,can any one tell me the answer?

9 Answers   Satyam,

---

What is forward declaration in pl sql?

0 Answers  

---