Re: Index optimizing on Oracle

Hi Chris,

        Don't worry about it. Unless you are running only a single user no two consecutive disk seeks are likely to be close to each other. However you can do a couple of things to optimize performance. First, use big db block buffers (64KB is a good size). This will result in Oracle reading 64KB at a time which should return a substantial number of records. Second, make sure that you have an index set up for the preferred sequence. It is also a good idea to pick up O'Reilly & Associates Oracle Performance Tuning Book and Oracle Press's Tuning Oracle.

Jerry

Chris Phillips wrote:
>
> Hello again,
>
> I am currently working on a project to port our product from SQL Server to
> the Oracle database. One of the major differences I have run into is
> clustered indexing. In SQL Server clustered indexing means that the table
> is physically ordered in the order the index is specified as. This helps
> in the retrieval of data if you are retrieveing the data sequentially. It
> appears that clustering is not the same on Oracle. What methods can I use
> to increase index preformance in this kind of situation.
>
> Thanks in advance,
>
> Chris
> cphillip_at_mindspring.com
Received on Fri Sep 26 1997 - 00:00:00 CDT