Abe Froman
Member
Version 9.1C17. Windows.
We're using a packaged banking software that offers little database structure to help reporting. I'd like to add some indices that boost reporting speed, but don't hurt the performance of the current software.
Everything drives off of one main table - lt-master.
The one index in question is
branch-key:
+ brch-entry
+ stage
It's not primary or unique.
I want to be able to do
FOR EACH lt-master WHERE stage = 60:
Should I:
A. Create an additional index with the single field 'stage' and leave the branch-key index intact.
B. Create an additional index with the single field 'stage' and remove stage from the branch-key index.
C. Do nothing. Both would cause problems
I am afraid to change the branch-key index for potential perfomance loss within the main program. If two single-field indices would work as well as a double-field index, then that could work.
I'd appreciate some advice.
We're using a packaged banking software that offers little database structure to help reporting. I'd like to add some indices that boost reporting speed, but don't hurt the performance of the current software.
Everything drives off of one main table - lt-master.
The one index in question is
branch-key:
+ brch-entry
+ stage
It's not primary or unique.
I want to be able to do
FOR EACH lt-master WHERE stage = 60:
Should I:
A. Create an additional index with the single field 'stage' and leave the branch-key index intact.
B. Create an additional index with the single field 'stage' and remove stage from the branch-key index.
C. Do nothing. Both would cause problems
I am afraid to change the branch-key index for potential perfomance loss within the main program. If two single-field indices would work as well as a double-field index, then that could work.
I'd appreciate some advice.