Hi Hilmar,

Using IDX indexes (create with INDEX ON ... TO somefile.idx) is unneeded you can use structural indexes (created with INDEX ON ... TAG someTag) which are automaticly released when the view is released.

Using IDX indexes also give problems (errors) when involved with transactions. CDX indexes do not suffer from this limitation.

Walter,


>>Will this create a permenate index? I really need a temporary one because this is a multi user app and I need to control the index files. Can you give me alittle more direction?
>
>Views can't have a permanent index.
>
>Temporary indices (IDX) are usually used on views.
>
>Use sys(2015) to obtain the filename - this will avoid conflicts in a shared folder.
>
>HTH, Hilmar.