MySQL Forums
Forum List  »  Optimizer & Parser

Re: table design and query opimization
Posted by: moraless92
Date: April 19, 2006 10:29AM

The first thing I'll do is to change function calls like cos('40.7874'/57.29577951) or ( 60 * 60 * 24 * 365 )) by the result of the operation. Despite query optimizers may do this for you it's a good idea to avoid unnecesary function calls and aritmetic operations.
To optimize the table design use the smallest type field for every field in the tables and add indexes for each field used in the inner join syntax.
By the way I won't like to be in your shoes ;)

Options: ReplyQuote


Subject
Views
Written By
Posted
2778
April 19, 2006 02:11AM
Re: table design and query opimization
1943
April 19, 2006 10:29AM
1573
April 19, 2006 10:25PM


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.