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 are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

899

---

what are date and time intervals? : Sql dba

998

---

What is join view in sql?

893

---

what is self-join? : Sql dba

1049

---

Why indexing is needed?

937

---

Determine if oracle date is on a weekend?

980

---

What is sql resultset?

928

---

What has stored procedures in sql and how we can use it?

1013

---

What are tables and fields in the database?

1022

---

What are aggregate and scalar functions?

973

---

What is snowflake sql?

1010

---

Define select, insert, create, delete, update, drop keywords

993

---

How do I find sql profiler?

883

---

how to drop an existing view in mysql? : Sql dba

994

---

Explain the difference between sql and mysql.

1000

---