Re: table design and query opimization

[moraless92]

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 ;)