Dear Ivan,

by ordering using index is slow, you mean in the insert (updating the index) or you mean in the select (using the select) ?

thanks
stephane

--- In firebird-support@yahoogroups.com, "Ivan Prenosil" <Ivan.Prenosil@...> wrote:
>
> > in this table around 50 000 000 records (and 20 fields)
> >
> > this index are motly here because we need to handle search and order for client in < 100 ms. so we need to index all possible case
> > of search
>
> But ordering using index is quite slow on the table of that size, your quieries will usually be slower than 100 ms anyway.
>
> Ivan
>