oracle performance question
From: Barry Roomberg <barry.roomberg_at_compudata.com>
Date: Tue, 7 Jun 94 21:40:00 -0500
Message-ID: <12a.2513.905.0N3E20C9_at_compudata.com>
Date: Tue, 7 Jun 94 21:40:00 -0500
Message-ID: <12a.2513.905.0N3E20C9_at_compudata.com>
-> We are testing a database with a single table containing 110,000
-> records of
-> 82-bytes each (distributed over 9 columns). An index is defined on
-> two of
-> the columns. The query is the simplest possible: 'select * from
-> TheTable'.
Hmm. 110,000 records * 82 bytes = 9,020,000 bytes.
No joins? Straight output?
This should take under 5 minutes to dump!
What else is going on on your system (if anything?).
Received on Wed Jun 08 1994 - 04:40:00 CEST