Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
John,
>> Is there any way to reduce the number of indexes? An index on every field?? Ouch. You might want to consider doing some research on data
organization and indexing as pertains to data warehousing. Data warehousing techniques and theory may help you find a better way to manage and
organize the data. <<
I'll have to look into this. The information is demographic and is received from an outside source. Worse, in the coming months we will receive tables on the order of 80 million records.
The one-index-per-field strategy is for a simple reason, information may be pulled based on any single field. Nevertheless, it is often pulled on more than one, rendering the many single indexes nearly valueless in optimization.
You are correct, it is likely more than an indexing question, but more of a data warehousing question.
>> Perhaps, also, you could spawn several child tables that offload data from the main and maintain separate indexes for each. You could monitor
data changes and then do logical reindexing. <<
I can see several approaches here, but will have to mull them over.
Thanks for the reply, it has me thinking of the larger issues.
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