Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Select max fro a table!
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