Re: oracle performance question
From: Anton Dischner <dischner_at_med.uni-meunchen.de>
Date: Wed, 8 Jun 1994 01:07:49 GMT
Message-ID: <dischner-070694170749_at_gkc12a.klch.med.uni-muenchen.de>
Date: Wed, 8 Jun 1994 01:07:49 GMT
Message-ID: <dischner-070694170749_at_gkc12a.klch.med.uni-muenchen.de>
In article <Cqztu1.J0n_at_world.std.com>, BThompso_at_world.std.com (Bill Thompson) wrote:
> 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
>
(.. stuff deleted ...)
Please be more specific:
Do you query in SQL-Plus; then the screen output my be a bottleneck.
Do you query through an network,
Do you make a full table scan ?
Do you query through ODBC ?
Did you separate index and data into seperate tablespaces ?
Do you query in an PRO-C program. (If so try to pin it into memory;
possible for unix)
...
Best regards,
Toni Received on Wed Jun 08 1994 - 03:07:49 CEST