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 ?
> >
>