How do you select an index for a table



How do you select an index for a table..

Answer / neha_gupta

The index for a table is selected , if there is a column
which is getting repetedly called in your queries.
On the data of the table the type of index can be selected.

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More Databases AllOther Interview Questions

How does rows store in Teradata

1 Answers  


What is odm database?

0 Answers  


How many types of locks are present in a database?

0 Answers   Abacus,


What is database client?

0 Answers  


What are the concurrency problems a database faces?

0 Answers   Amazon,






What is the difference between primary key, foreign key and candidate key?

0 Answers   Ernst Young,


hai if any one having any project sample table structure please froward to my mail id tauseefwst@yahoo.com

0 Answers   HP,


What is the best database?

0 Answers  


Clipper / DBF error

1 Answers  


Explain alternate key?

0 Answers  


What will happen non-clustered index will be created on clustered index?

0 Answers   Abacus,


What is the relationship that exists inside in E-R diagram?

0 Answers   CGI,


Categories