Gov
Guest
Hello,
With P4210, we are experiences considerable time difference when we do search (using QBE) on DOC compared to DOCO. I think primary index on DOCO might be the difference. One of my colleague recommended that creating an index on DOC (only) worked with Oracle db earlier in his experience. I am not sure how QBE filtering works with index choosing. Is some one come across similar scenario and had a solution?
Appreciate your insight!
Thanks,
With P4210, we are experiences considerable time difference when we do search (using QBE) on DOC compared to DOCO. I think primary index on DOCO might be the difference. One of my colleague recommended that creating an index on DOC (only) worked with Oracle db earlier in his experience. I am not sure how QBE filtering works with index choosing. Is some one come across similar scenario and had a solution?
Appreciate your insight!
Thanks,