Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

should i index the columns used in a faceted search page?

satishpMar 6 2022 — edited Mar 6 2022

will that help improve performance? is that a best practice?
Please note that the main query feeding the classic report / card container (linked to the faceted search) is properly optimized with the right indexes.
Using an example, say I have a Product table with a lot of meta-data.. should i be creating indexes on all the facets like price, category etc...

Comments
Post Details
Added on Mar 6 2022
3 comments
520 views