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 does stand for in sql?

523

---

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

601

---

What is the importance of sqlcode and sqlerrm?

848

---

What are the types of queries in sql?

519

---

Does user triggers have entry for trigger with compilation errors?

595

---

---

Can we rename a column in the output of sql query?

542

---

Is left join faster than join?

545

---

How can use stored procedures in sql?

582

---

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

565

---

What is sql rowcount?

556

---

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

537

---

i have some prob lem to tell me about my self in interview first round ...

1701

---

Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

533

---

how to convert character strings to dates? : Sql dba

525

---

Define commit, rollback and savepoint?

576

---