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>


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

Original text of this message