Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> What is more efficient?
Hi,
I am in the process of setting up a reporting for our app. and would like
your opinion on what would be a better ( more efficient solution )
For most reports data will be extracted from two tables and the union of
those would be nedded to for some.
There are two scenarios which I am considering ( if you think that I am mad
and you think that it should be done in complitly different way please let
me know) one creating indexes on those tables and just run query against
those the other would be generating temp table which would be a subset of
the records and run the reports against that temp table.
There are around 7 different reports to be run per customers for about 130
customers.
thanks in advance
robert
Received on Mon Mar 30 1998 - 00:00:00 CST