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 the difference between inner join and outer join?

709

---

Difference between truncate, delete and drop commands?

730

---

What program will open a mdb file?

675

---

What is the cause of mutating table error and how can we solve it?

780

---

What is java sql package?

734

---

---

What is group function in sql?

748

---

How do I view a sql trace file?

756

---

What is sql and db2?

722

---

What is the difference between cluster and non-cluster index?

803

---

Is primary key always clustered index?

733

---

define data blocks ? : Sql dba

735

---

Can we create view in stored procedure?

685

---

What is trigger point?

732

---

Is sqlite good enough for production?

730

---

What are sql commands?

692

---