I didn't say it wouldn't create them. The question is whether it will
take advantage of them.

In Oracle I have

Index1 = Column1
Index2 = Column2
Index3 = Column3
Index4 = Column1, Column2, Column3

In Oracle, if the select or where clause takes can take advantage of
Index 4 it will use
it over 1, 2, and 3; In addition, Oracle will use a "complex" index for
doing joins on
tables. I was told that IB could not and would not try to take
advantage of Index 4.
It would piece together Indexes 1, 2, and 3.

Is this true? and what is the best way for FB today?

Claus Heeg wrote:

>Thomas
>indexes of multiple columns run since 10 year at us this is bu%%-sh%%
>what you have been told.
>the other thing never seen either. We use unique keys (we keep ignoring
>constraints...)
>... but use programming tools and "data dictionary" for such
>constraints a.other plausi-features.
>
>
>yours
>Claus
>
>
>Thomas Miller wrote:
>
>
>
>>We currently write our software for Oracle and I am very familiar with
>>how Oracle
>>uses indecies for speed. We are currently converting our software to
>>also run on
>>FB.
>>
>>Back in the 5.x days of IB, I was told never to create indecies made up
>>of multiple
>>columns. Is that still true? Any other insights would also be welcome.
>>
>>When I create a primary key, the engine makes two indexes. One as a primary
>>key and one that it not. They both are indecies of the primary key. Is
>>this a bug?
>>
>>
>>
>
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>

--
Thomas Miller
Delphi Client/Server Certified Developer
BSS Accounting & Distribution Software
BSS Enterprise Accounting FrameWork

http://www.bss-software.com



[Non-text portions of this message have been removed]