>Just to elaborate more, I have deleted the 4 tags I am using in the SQL. I have indexed them again. I still have the same behavior. If I put the NOFILTER clause it's ok. If I don't, I have too many records in my SQL.
>
>With the NOFILTER, I have 281 records. Without, I have 778 records.
>
>So, as for a SQL, it's ok as I can force a NOFILTER and this solves the problem. However, for a COUNT I can't so I have the same behavior.
This rings a real faint bell... could you try DESC instead of DESCENDING? I know, there should be no way on earth it should make a difference, but...
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up
