Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Ria,
How many records in the table in question... are you sure the system is hung, or might it be just taking a long time to process?
If there are lots of records then it could be that you don't have all of the indexes needed to make the query run as fast as possible.
Also, how much RAM on the machine wioth the problem?...Is it a workstation on a network?...What OS is running on the workstation?...Is there a virus scan program running on the machine?
good luck
>Hi,
>I have a program, that allows the user to look up data on various tables in a database. While all queries work, when a query is executed on one specific table, the system just hangs. What could be th problem? Is it likely that this table is corrupted and needs to be reindexed?
>
>Thank you.
>
>Ria
Précédent
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