!indexes in sqlline shows empty

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

!indexes in sqlline shows empty

you Zhuang

Does sqlline be not accurate ? 

When I query columns in index , explain plan shows not using the index.
Reply | Threaded
Open this post in threaded view
|

Re: !indexes in sqlline shows empty

Vincent Poon-2
try this:
!indexes <tablename>

On Tue, Aug 20, 2019 at 12:29 AM you Zhuang <[hidden email]> wrote:

Does sqlline be not accurate ? 

When I query columns in index , explain plan shows not using the index.
Reply | Threaded
Open this post in threaded view
|

Re: !indexes in sqlline shows empty

you Zhuang
Awesome , it works , thanks.

On Aug 21, 2019, at 5:35 AM, Vincent Poon <[hidden email]> wrote:

try this:
!indexes <tablename>

On Tue, Aug 20, 2019 at 12:29 AM you Zhuang <[hidden email]> wrote:
<PastedGraphic-1.tiff>

Does sqlline be not accurate ? 

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