MySQL Forums
Forum List  »  Optimizer & Parser

Re: Optimizing query with joins
Posted by: Rhonda Heath
Date: February 12, 2007 12:07PM

This may be an extremely fundamental suggestion, but your DBA may need to review the tables themselves with an eye toward more stringent normalization. Statistically speaking, slow database performance is due most often to suboptimal schemas and poor normalization. Breaking down huge tables into smaller ones through a well-disciplined normalization process speeds up database searches by a significant time margin.

Options: ReplyQuote


Subject
Views
Written By
Posted
3219
June 03, 2006 12:18PM
2015
June 07, 2006 10:17AM
Re: Optimizing query with joins
2008
February 12, 2007 12:07PM


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.