[PHOENIX-5456] IndexScrutinyTool slow for indexes on multitenant tables

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.15.0, 5.1.0
• Fix Version/s: 4.15.0, 5.1.0
• Assignee: Gokcen Iskender
• Reporter: Vincent Poon
• Created: 27/Aug/19 23:51
• Updated: 21/Dec/19 00:57
• Resolved: 20/Nov/19 20:41

Description

The IndexScrutinyTool is doing full scans for index tables on multitenant tables.
This is due to a change in PHOENIX-5089, where we added code to IndexColumnNames to skip a portion of the PK if the table is multitenant:

https://github.com/apache/phoenix/commit/cc9754fff840f38d13c3adb0c963296959fff3fa#diff-0705645faa779229d00792c032ed377fR64

This causes scrutinies for global, non-view indexes on multitenant tables to skip the tenantId when generating the pk column list, thereby causing a full scan.

Issue Links

• is related to: PHOENIX-5089 IndexScrutinyTool should be able to analyze tenant-owned indexes
• links to: GitHub Pull Request #575