yes, that work perfectly, but without any order by unfortunatly :(
the main probleme is the order by ...

--- In firebird-support@yahoogroups.com, Doug Chamberlin <dougchamberlin@...> wrote:
>
> 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?
>