Oksana March (11/5/2012)
Hi everyone,I have a dilemma and need your advice.
We have a customer that runs a report that retrieves very detailed data and takes about 5 minutes to complete for a period of 1 day. The query is optimized and the right indexes are set up, it takes that much because it's a lot of data. This president of the client company tried to specify a date range of 1 year and of course the query was just running and running. He complained the query doesn't work. I tried to explain that this report lists every transaction and it's not designed to be run for more than 1 day but he insists to run it for one year. How would you explain it to this big boss politely in an email message?
So, how many transactions are there for a year?
--Jeff Moden
Change is inevitable... Change for the better is not.