In article <bdh2ud$s9f$1_at_ctb-nnrp2.saix.net>, vslabs_at_onwe.co.za says...
> 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
>
>
Create a new Microsoft Access database, link your Oracle tables w/ ODBC,
and do the SELECT COUNT(*) from there ;-)
Received on Fri Jun 27 2003 - 05:09:46 CDT
