Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
We are running on an NT4.0 sp6 server with nt40 and win2000 workstations.
There are probably no more than 6 people in the table at one time.
The application is built on Visual Promatrix. The referential integrity is not working, the queries are slow and the relate to a GIS coverage doesn't work any more as well as reindex command not working.
The indexes for the table is
stand township+range+section+stand
ostand township+range+section+ostand
compartno PADL(ALLTRIM(STR(compartno)),2,"0")+township+range+section+stand
deleted DELETED()
record_no "A"
birthyr STR(birthyr)+covertype+fsilv
The other tables all have similar indexes. The indexes are non structural .cdx's
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