Subject Re: [firebird-support] Re: Table with more than 100 index.
Author Doug Chamberlin
Alexandre Benson Smith wrote:
> My first attempt would be to create an index for each individual field.

I would do the above except not for columns ID_Place, Status, Kind, or
Subcategory. Then add one combination index for ID_place + Status + Kind
+ Subcategory since you know those values will always be used.

Try it and let us know how well it worked.

Doug C.
A: Because it messes up the order in which people normally read text.
Q: Why is top-posting such a bad thing?
A: Top-posting.
Q: What is the most annoying thing in e-mail?