MySQL Forums
Forum List  »  Optimizer & Parser

Re: Optimize a query fetching huge data
Posted by: Anil Pathak
Date: July 22, 2008 03:33AM

I broke up a large table into many tables. For example for product table i have product_a for all products from brands starting with a, and so on.
Its fast now.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Optimize a query fetching huge data
2813
July 22, 2008 03:33AM
2953
September 01, 2008 12:02AM


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.