Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
How To Add Index To A Database At Runtime
Versions des environnements
Hello Everyone....
I have a database with multiple tables. One of the table hav 1.5 mil records and 10 indexdex.
I have an indexing function which pack the tables and then reindex. The index was taking a very long time.
Before packing the table, I decided to use DELETE TAG ALL command and then created brand new index tags
by using INDEX on... TAG ??? command. It did speed up the process but in a runtime version, I get the following error:
Index Tag ??? was not found. Would you like to add the Index Tag to the database ???.
What command I can use to add these index to a databse programatically?
Any help is appreciated. Thank you in advance...
Raz
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