Mike Yearwood
Toronto, Ontario, Canada
Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Hi Mike:
special case of Datamining...
the table is *only* written to before any index is created.
All the indeces are used in more than one query -
and here the index involving the UDF is created always again -
and I need it also in some seek/scan - scenarios, so I have
to create it myself as well.
I will probably create redundant fields, as indeces on those
can easily be reused. That should still leave me with 18 months
until I reach th2 2 Gig barrier again <g>.
regards
thomas
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