Some databases MS-SQL, Sybase, and I think Oracle too have
Clustered-Indexes, wich is teh physical order of the data, but AFAIK IB/FB
does not have this kind of indexes.

Clustered index have good and bad points, Clustered index is good when you
have low-selectivity or when you whant to search in ranges (something like
Date between X and Y), this perform ok for the select, because you read a
bunch of records in each page that holds the data you want, the leaf pages
of these indexes are the data pages. but in MS-SQL you can get concurrency
problems in inserts because of the table lock used by MS-SQL (I am talking
about SQL 6.5 that I used, do not know for newer versions) there are greate
chances taht you have to insert in the same page that is locked-up.

I think FB/Ib bitmapped indexes could have some beneffits like clustered
indexes.

see you !

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br

At 14:19 28/11/2002 +0000, you wrote:

>Hi,
>
>Is it possible to change physical order of a interbase table
>to correspond to some index?
>
>Thank you in advance
>Hristo Aladjov