[PHOENIX-4882] The client re-resolves the table for every projected non-indexed column when there's a local index.

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.14.0
• Fix Version/s: 4.15.0, 5.1.0
• Assignee: Lars Hofhansl
• Reporter: Lars Hofhansl
• Created: 31/Aug/18 06:30
• Updated: 21/Dec/19 00:54
• Resolved: 06/Sep/18 18:30

Description

See TupleProjectionCompiler.ColumnRefVisitor.

Each non-projected column causes a server roundtrip in LocalIndexDataColumnRef.

For wide tables that can be hundreds of time.

I generally find that the same table is resolved over and over again for other reasons as well (I counted 15-25 times during query compilation!!)

Put a break point in ConnectionQueryServicesImpl.getTable and you'll see.

tdsilva

Issue Links

• relates to: PHOENIX-4962 Ensure that a table is resolved only once per query compilation