Cache does not support this syntax. We do the opposite letting you tell us where we should NOT use an index.
WHERE Age > 0
Will return all the people in the data base so if there is an index on Age it would not be helpful here. You can tell us to avoid that index by adding the hint %NOINDEX before the condition
WHERE %NOINDEX Age > 0
Hope this helps
IRIS, Caché, Ensemble
You received this message because you are subscribed to the Google Groups "IRIS, Caché, Ensemble" group.
To unsubscribe from this group and stop receiving emails from it, send an email to intersystems-publi...@googlegroups.com.
To post to this group, send email to intersystems...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.