Обсуждение: monitoring

Поиск
Список
Период
Сортировка

monitoring

От
"Mohammed A"
Дата:
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

Re: monitoring

От
Nabil Sayegh
Дата:
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