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 CEST
Original text of this message
