>i forget to say that it's meanly because of different "order by" choice that i need all thoses index ...
>
> --- In firebird-support@yahoogroups.com, "svanderclock" <svanderclock@...> wrote:
>>
>> yes absolutely of absolutely (of the absolutely) sure that i need all thoses index ! and 30 index for one table is not look too
>> much exagerated :(
>>
>>
>> --- In firebird-support@yahoogroups.com, "Ivan Prenosil" <Ivan.Prenosil@> wrote:
>> >
>> > > > Are you absolutely sure that you really need all these indexes?
>> > >
>> > > sure, and absolutely sure ! because it's a critical that select query return in < 100 ms, and for that we need all theses
>> > > index :(
>> >
>> > Are you absolutely sure that you are absolutely sure ?

Haaa, I knew that :)

You can have much less indexes with only one or two segments (depending on selectivity),
and do "fine sorting" on the client.

Yes, it is more work for you, but the alternative exists :)

Ivan
http://www.volny.cz/iprenosil/interbase/