New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Add a JSON Index #10

Open

Michael-A-McMahon opened this issue Jul 18, 2024 · 0 comments

Labels

Collaborator

Michael-A-McMahon commented Jul 18, 2024

A JSON index on our metadata column may improve performance of the search method when a Filter is provided.

We should research available options here https://docs.oracle.com/en/database/oracle/oracle-database/23/adjsn/indexes-for-json-data.html. We can choose something well suited for the metadata document, which is a flat object having no arrays or nested objects.

We should benchmark any changes we make here. We need to verify that the change actually helps performance.

Michael-A-McMahon added the enhancement label

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment