Ferrari_NYC wrote:
> Hello
>
> We do have a batch process which runs a bunch of inserts, updates and
> select statments.
>
> Some of the SELECT statments are taking around 1-2 secs on empty
> tables.
>
> What does that really means?
It means the high water mark is in the stratosphere. Does your database
have a version number? I'd suggest TRUNCATE TABLE and an EXPLAIN PLAN
if you repost about this.
--
Daniel Morgan
University of Washington
Puget Sound Oracle Users Group
Received on Wed Sep 20 2006 - 10:03:18 CDT
