MySQL Forums
Forum List  »  Optimizer & Parser

Re: optimizing the query.
Posted by: Toa Sty
Date: August 04, 2006 04:50AM

Unless you're doing extremely high volumes of inserts adding a few indexes won't hurt you too much and will allow you to query the table orders of magnitude more quickly.

Without indexes you're always gonna perform a full table scan, and that's always gonna take a long time on a large table.

So add some indexes and let us know how you get on :)

Options: ReplyQuote


Subject
Views
Written By
Posted
2564
July 26, 2006 07:13AM
1738
July 27, 2006 12:13AM
Re: optimizing the query.
1811
August 04, 2006 04:50AM
1836
August 22, 2006 12:37PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.