Re: POL: Why needs DELETE so much time???

Hi Andreas,

If I understand you correctly it is taking hours to delete one row from the table. Since your delete statement references the primary key and you have a small table the deletion should occur instantaneously.

Since it does not I suspect that you have a corrupt table or index. The solution, of course :-( , is to recreate them -- if necessary. First, find out if the structures are valid using:

        ANALYZE TABLE bad_guy VALIDATE STRUCTURE CASCADE;

This will return a message indicating either that your structure is valid or that there is an error. If there is an error you will have to drop and recreate the offending object. Note, that if the index is invalid you do not have to drop the table -- only the index.

Regards

Jerry

Andreas Seebeck wrote:
>
> Hi,
> I have another problem with Personal Oracle Lite:
> The command
> DELETE FROM table WHERE nr = 100000
> needs hours (in a table with 300000 records)!
> The command
> SELECT * FROM table WHERE nr = 100000
> on the same table needs just milliseconds.
> nr is the primary index, of course.
>
> Can anybody tell me what kind of sh... happens here? If this problem can't
> be solved, how can Oracle sell such a database? And we have to buy a new
> database and begin developing again...
>
> Thanks in advance for any advice,
>
> Andreas
>
> --
> -----
> This Message was send via Microsoft Mail and News

--
Jerry Gitomer Since I know how to spell DBA I became one. jgitomer_at_p3.net Received on Wed Apr 15 1998 - 20:59:28 CDT