Answer Posted / jeevan

Index is nothing but an identification of each row. It will be used for quick search.

Types Of Index:
---------------

Clustered Index:
Clustered index is a physical sorting of database table’s rows in a storage media. For this reason, each table may have one clustered index. If a primary key constraint is created for a table but no clustered index exists for a table, then SQL server automatically create a clustered index on a primary key.

Non Clustered Index:
Non clustered index are created outside of the table and contain a sorted list of references to a table itself. Maximum we can use 249 clustered indexes per table.

Note:
Only 1 clustered Index can be used per table.
Maximum 249 non clustered index can be used per table.

what is heap table? : Sql dba

1137

---

How exception handling is done in advance pl/sql?

1022

---

What is sql indexing?

1062

---

What is sql query limit?

1020

---

Why do we use joins in sql?

1006

---

Which is the correct statement about truncate and delete?

1172

---

Mention what is the function that is used to transfer a pl/sql table log to a database table?

1033

---

Can we group by two columns in sql?

1046

---

how can you see all indexes defined for a table? : Sql dba

1052

---

What are the query optimization techniques?

999

---

what is “go” in t-sql? : Transact sql

1155

---

What is the difference between an inner and outer join?

1058

---

how to create a table index in mysql? : Sql dba

1121

---

Why do we use joins?

1097

---

Write an sql query to select all records from the table?

1077

---