You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@phoenix.apache.org by you Zhuang <zh...@gmail.com> on 2019/08/20 07:28:14 UTC

!indexes in sqlline shows empty


Does sqlline be not accurate ? 

When I query columns in index , explain plan shows not using the index.

Re: !indexes in sqlline shows empty

Posted by you Zhuang <zh...@gmail.com>.

Awesome , it works , thanks.

> On Aug 21, 2019, at 5:35 AM, Vincent Poon <vi...@apache.org> wrote:
> 
> try this:
> !indexes <tablename>
> 
> On Tue, Aug 20, 2019 at 12:29 AM you Zhuang <zhuangzixiaoyou@gmail.com <ma...@gmail.com>> wrote:
> <PastedGraphic-1.tiff>
> 
> Does sqlline be not accurate ? 
> 
> When I query columns in index , explain plan shows not using the index.

Re: !indexes in sqlline shows empty

Posted by Vincent Poon <vi...@apache.org>.

try this:
!indexes <tablename>

On Tue, Aug 20, 2019 at 12:29 AM you Zhuang <zh...@gmail.com>
wrote:

>
> Does sqlline be not accurate ?
>
> When I query columns in index , explain plan shows not using the index.
>