Re: Simple Oracle Query Taking Too Long

Bryan Hunter wrote:
> I did run an explain plan and it shows :
> Count Stopkey
> Table Access Full
>
> I also ran it on a different table similar in structure but has a primary
> key and two columns indexed which I do not believe are important in this
> problem and recieved the same explain plan but milisecond response time.
>
> The table in question is only being accessed by the procedure that is moving
> the data from that table to the other one. So there are no inserts or
> updates being performed on this table. So I assume since that since there
> is no data manipulation occuring that the data stays intact and that the
> select and delete get the same data.

RENAME slow_table TO slow_table_hold;

CREATE TABLE new_table AS
SELECT * FROM slow_table;

My guess is you have a high water mark in the ionosphere.

-- 
Puget Sound Oracle Users Group