Re: Select max fro a table!

From: <rspeaker_at_my-dejanews.com>
Date: Fri, 22 Jan 1999 18:11:52 GMT
Message-ID: <78af0t$7u1$1@nnrp1.dejanews.com>

The problem could be that your PK index is fragmented and needs rebuilt.

In article <788km3$5hc1_at_news.hk.linkage.net>, "Yeung Man" <yngm_at_chowsangsang.com> wrote:
> 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
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Jan 22 1999 - 12:11:52 CST