Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Slow SQL on empty table

mohitanchliaDec 10 2008 — edited Dec 11 2008

Oracle 10g:

I am seeing execution time on one of the SQL that does select on "empty" table take from 500ms-1sec. Could some tell me why would that take so long?This table is always empty and no inserts/updates are being performed on this table.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 8 2009

Added on Dec 10 2008

#general-database-discussions

4 comments

1,617 views