Walter Meester
HoogkarspelPays-Bas
Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement