Subject Re: [firebird-support] Table with more than 100 index.
Author Ivan Prenosil
> 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