Paul,
Have you looked at the details in the Caché SQL manual about optimizing performance:
http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY…
Play particular attention to the section about using TuneTable to properly set the meta-data around table extent size, selectivity, etc. Lot of people miss this and it's very important because the query plans rely on this metadata to optimize performance.
- Log in to post comments