Re: My database is too fast

Billy Verreynne wrote:

> Dear Comp.Databases.Oracle.Server,
>
> I have loaded 77 million rows into a single partition in a partition table.
> The other partitions are empty.
>
> A "select count(*) from table" took 3.07 seconds. Neither table nor
> partition indexes are analyzed!! This is horrifying!
>
> I'm nervous to load the rest... will the database not be too fast?
>
> Will this not damage the Oracle perception of SQL-Server users?
>
> Will it not upset Bill Gates?
>
> And what about the developers? Pretty soon they could be thinking they don't
> need a DBA anymore to ask for performance tuning assistance when the
> database is this fast.
>
> Management otoh may expect this type of performance from my databases all
> the time!
>
> What to do!?
>
> Yours Sincerely,
> A DBA in quandary
>
> --
> Billy

Add ORDER BY to your query.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)