>
>Well, it automatically deletes the cdx(1), i.e. the first index _file_ (which can contain many tags), unless it belongs to the underlying table (this is the case with a filtered-view cursor).
>

You're quite correct in that a non-structural CDX on a SQL cursor will get removed automatically when the cursor is closed. I'll have to keep that little trick in mind, because it does not require that the SQL cursor be made R/W. Thanks for that useful tidbit.

>WHERE clause doesn't help for creating a no-filter cursor; on the contrary, if it returns a small recordset (in case of a real WHERE, not WHERE .t.), you are more likely to get a filter, because its memory footprint is small and there's no need to go to disk for it. Adding a dummy field should give you a no-filter, which then doesn't have a .cdx file, and doesn't borrow one from the underlying table.
>

I've always found that a WHERE .t. forces it to be a non-filtered cursor, no matter what size the result set is. But I have used a dummy field, also, with the same results.

>If we continue like this, we'll become experts on the matter :)

Gee, we certainly sound like we know what we're talking about! ;)