Query Timeout expire error
420445Dec 23 2004 — edited Dec 23 2004I have one view named "GetDailyTspecExceptionList" which is based upon the other view named "GetDailyTspec" which is based upon some master tables.
Since the "GetDailyTspec" view is not returing any value so the view "GetDailyTspecExceptionList" will also return empty. But when the query:
SQL> select max(TspecDate)as mdate from GetDailyTspecExceptionList;
is executed the error
"Timeout Expired Query" is returned through the frontend.
Even though the view is empty i cant understand why the query is displaying timeout & take too much time for executing.
Thaks in advance.