>Hi
>
>Do SQL-Selects create a temporary index on a field if the field you are checking is not indexed?
>
>If not, is it better to create an IDX before doing a Select to speed it up?
>
>Thanks
>Kev
Kevin,
Rushmore decides what to do and might create temporary indexes itself.
If you have a persistent index in structural CDX than it's better.
Cetin