Mike Yearwood
Toronto, Ontario, Canada
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only