Is it advisable to force an index when you want to select most of the entries in the table?

  • Interview Candidate
  • 4
  • 1544

Showing Answers 1 - 4 of 4 Answers

sangeeta

  • Jun 1st, 2005
 

yes

  Was this answer useful?  Yes

nvsora

  • Oct 11th, 2005
 

If table has many columns as well as large, and you want to access only indexed columns, then it is yes.

If you are selecting columns those are not indexed, and still you are using index then it will increase disk I/O which will drag performance of the query as well database.

John Netherwood

  • Nov 14th, 2007
 

No it isn't.  If you are going to select most of the entries then you will have to read through the entire table anyway.  Forcing the use of an index will just be an extra overhead.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions