I am having a SELECT statement with DISTINCT, GROUP BY, CASE clauses. This is used to create a report. But each time I run the query, the total time taken by it, is increased. Please somebody tell me why this happen so.
Joined: 23 Nov 2006 Posts: 19270 Location: Inside the Matrix
Please post your full query, the definition of the table(s) referenced, approximately how many rows are in each table, and the growth rate for the tables. Do the tables have purge criteria (i.e. are rows regularly deleted or will this continue to grow with no restraint)?
Did this suddenly happen or has the time been increasing over some period of time.