Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Select max fro a table!

Select max fro a table!

From: Yeung Man <yngm_at_chowsangsang.com>
Date: Thu, 21 Jan 1999 19:17:56 +0800
Message-ID: <788km3$5hc1@news.hk.linkage.net>


Hi,

    We have a table as Table_A ( val_dte not null, count number(4)) where val_dte is primary key. If we issue the sql

        select max(val_dte) from TAble_A;     The sql has a long time to run. We use the explain plan as find the sql use the pk. Do anyone have idea what going on.

    TIA. Best Regards,
Man Received on Thu Jan 21 1999 - 05:17:56 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US