binarycat0 commented on code in PR #2465: URL: https://github.com/apache/polaris/pull/2465#discussion_r2314017635
########## persistence/relational-jdbc/src/main/resources/h2/schema-v2.sql: ########## @@ -63,6 +63,7 @@ CREATE INDEX IF NOT EXISTS idx_locations ON entities(realm_id, catalog_id, locat -- TODO: create indexes based on all query pattern. CREATE INDEX IF NOT EXISTS idx_entities ON entities (realm_id, catalog_id, id); +CREATE INDEX IF NOT EXISTS idx_entities_lookup ON entities (realm_id, catalog_id, parent_id, type_code, sub_type_code, id, name); Review Comment: I'm not sure. I was trying to follow the comment above: `-- TODO: create indexes based on all query pattern` I can remove this change if it's not relevant. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
