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?