Обсуждение: monitoring
Dear All,
Is any way to monitor the execution of the query, for example a query;
SELECT L_ORDERKEY, L_EXTENDEDPRICE, L_DISCOUNT, O_ORDERDATE, O_SHIPPRIORITY FROM C_, O_, L_
FROM L_, O_, C_
WHERE C_MKTSEGMENT='BUILDING' AND C_CUSTKEY=O_CUSTKEY AND L_ORDERKEY=O_ORDERKEY
AND O_ORDERDATE <'1995-03-15' AND L_SHIPDATE > '1995-03-15'
Is any command to monitor the time for joining...etc all the query activities?
please let me know as soon as possible.
thank you
On 02 Jun 2001 23:21:42 +0100, Mohammed A wrote: > Dear All, > > Is any way to monitor the execution of the query, for example a query; > > SELECT L_ORDERKEY, L_EXTENDEDPRICE, L_DISCOUNT, O_ORDERDATE, O_SHIPPRIORITY FROM C_, O_, L_ > FROM L_, O_, C_ > WHERE C_MKTSEGMENT='BUILDING' AND C_CUSTKEY=O_CUSTKEY AND L_ORDERKEY=O_ORDERKEY > AND O_ORDERDATE <'1995-03-15' AND L_SHIPDATE > '1995-03-15' > > Is any command to monitor the time for joining...etc all the query activities? Not quite monitoring, but you can extimate it using EXPLAIN <QUERY> cu -- Nabil Sayegh