Is there a way to get Impromptu to use the proper index (Oracle DB). I have two indexes which compete with each other. Several of my reports have prompts for a date range, and therefore use the "order date" index, while other reports do not have a date range prompt, and use the unique index "order_key, "company_key". However, every time I run a report, in which I want the DB to use the "order date" index, it uses the other index. It will only use this index if I specify a particular "company_key".
If I remove this filter, it uses the "order date" index. Unfortunately, I need to keep this filter in the report.
I was hoping that there was a way, in defining the joins in the catalog that would help with this.
I DO NOT want to use optimizer hints!!
Any help would be appreciated!
Trevor
If I remove this filter, it uses the "order date" index. Unfortunately, I need to keep this filter in the report.
I was hoping that there was a way, in defining the joins in the catalog that would help with this.
I DO NOT want to use optimizer hints!!
Any help would be appreciated!
Trevor