View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Newbie09 Newbie09 is offline
external usenet poster
 
Posts: 1
Default Should I save a new query for each report or use the same and modi

I have several reports that pull data from SQL and Oracle databases. I notice
the retrieval time from the Oracle database is much slower and have modified
the queries to speed them up. My question is when I create a report, I do not
save the query as a seperate query for that particular report. So the default
query is always used I just change the parameters. Will saving seperate
queries for each report gain me anything? Thanks