Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
UDF's second rate citizen in Rushmore ?
Message
From
07/09/2006 10:44:33
 
 
To
07/09/2006 09:52:41
Mike Yearwood
Toronto, Ontario, Canada
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01151219
Message ID:
01151813
Views:
39
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
Map
View

Click here to load this message in the networking platform