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 ;)
Subject
Views
Written By
Posted
2862
April 19, 2006 02:11AM
Re: table design and query opimization
2008
April 19, 2006 10:29AM
1629
April 19, 2006 10:25PM
2004
April 27, 2006 11:27AM
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.