Re: Speed - which would be faster
If your queries are optimized (they use the index, they don't have wasteful joins and subqueries, they don't use SELECT *, etc), then yes it will be fine. Breaking it into seperate tables would only make it worse - the server would have to open more tables which creates extra disk I/O and so on.
Subject
Written By
Posted
Re: Speed - which would be faster
March 24, 2005 04:33PM
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.