[ https://issues.apache.org/jira/browse/PHOENIX-4882?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Lars Hofhansl updated PHOENIX-4882: ----------------------------------- 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-20 times during query compilation.) [~tdsilva] was: See TupleProjectionCompiler.ColumnRefVisitor. Each non-projected column causes a server roundtrip in LocalIndexDataColumnRef. For wide tables that can be hundreds of time. > The client re-resolves the table for every projected non-indexed column when > there's a local index. > --------------------------------------------------------------------------------------------------- > > Key: PHOENIX-4882 > URL: https://issues.apache.org/jira/browse/PHOENIX-4882 > Project: Phoenix > Issue Type: Improvement > Reporter: Lars Hofhansl > Priority: Major > > 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-20 times during query compilation.) > [~tdsilva] -- This message was sent by Atlassian JIRA (v7.6.3#76005)