>>I think I'm right, but I'll try with NOT INLIST just for test.
>>
>>My other question is how can I find all IDX files for the table with their keys? Perhaps I have additional indexes on Styles table that can help me to speed up my query...
>
>I, like Tore said, do not use IDX since many, many years, but I believe you should recreate them on aplication startup, probably on a local temp folder to be 100% sure they are up to date (or is it up todate? or uptodate? upto date?), so you should not have any problem finding them <g>
Interesting idea... But, I take it as there is no simple way to find out IDX associated with the particular table...
If it's not broken, fix it until it is.
My Blog