1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

What is the advantage of index in sql?

Question Posted / sathya


What is the advantage of index in sql?..

Answer / Anirudh Sharma

Indexes can significantly improve SQL performance by allowing quicker access to specific rows within a table. This is especially useful for large tables or frequently executed queries.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

what is definer rights invoke rights?

1 Answers  

Define SQL and state the differences between SQL and other conventional programming Languages?

1 Answers  

How to display Row Number with Records in Oracle SQL Plus?

1 Answers   MCN Solutions,

What is user in sql?

1 Answers  

What is a primary key called that is made up of more than one field?

1 Answers  

what is the different between unique+not null & primary key,

4 Answers  

Store procedure will return a value?

4 Answers   eMids,

what are %TYPE and %ROWTYPE? what is the difference?

7 Answers   ICICI, Saama Tech, Sail,

Is it possible to create the following trigger: before or after update trigger for each row?

1 Answers  

Is and as keyword in pl sql?

1 Answers  

What is an oracle stored procedure?

1 Answers  

Give an example of Full Outer Join?

1 Answers   IBM,

For more SQL PLSQL Interview Questions Click Here
Categories