Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Binary index based on field value
Message
From
21/01/2007 20:10:51
Neil Mc Donald
Cencom Systems P/L
The Sun, Australia
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Binary index based on field value
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01187555
Message ID:
01187555
Views:
64
Hi,
With binary indexes are you able to create a logical binary index based on the value of a numeric field i.e. IIF(osbalance=0,.F.,.T.) and have rushmore optimize it within a select.
i.e. Select * from invoice where osbalance=.T.

It would save a lot of space in the index and should be faster as well.
Regards N Mc Donald
Next
Reply
Map
View

Click here to load this message in the networking platform