Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> My database is too fast
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
-- BillyReceived on Fri Jun 27 2003 - 03:37:35 CDT
![]() |
![]() |