Re: db_file_multiblock_read_count

Hi,

It can make sense if the index is NON-UNIQUE => ( so not a primary key nor a unique constraint ).

For such small table you can cache then if they are often queries.

Becarefull to some funy result from the optimiser !

Regards François.

Nuno Martins <nunomartins_at_mail.telepac.pt> wrote in article <34118AE4.4F4C7477_at_mail.telepac.pt>...
> Hello,
> if i have a db_file_multiblock_read_count = 32 then it thas not make
> sense having a index in tables with less than 64k . Is this true ?
>
> What´s are your opinion ?
>
>
>
>
Received on Sat Sep 06 1997 - 00:00:00 CDT