Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Hi All,
I have this table of size 1 GB , and it is a part of a CALL CENTER APPLICATION, which means it is being accessed by atleast 40 users at any given point of time. Since it is a CUSTOMER TRANSACTION, it gets hit atleast half a dozen or more times a minute.
The question is I get Index problems, every once a week the INDEX is corrupted, and I have to recreate the index. And since this table is 1 GB and has 6 indices on it. It takes much more time and the call center is down once every 10 days for atleast 2 hours.
Can someone help me out please ??
Thanks in Advance
D.
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