Re: Comprehensive Guide for EXPLAIN

Yes, the EXPLAIN plan documentation is a section in the Tuning Guide that would be super valuable to fill in. It'd be much appreciated if you could move that forward. Thanks, James On Thu, Sep 29, 2016 at 10:52 AM, Peter Conrad wrote: > James: > > Should I work on

Re: Comprehensive Guide for EXPLAIN

James: Should I work on putting together documentation on how to read an EXPLAIN plan? If so, what's the best way for me to get more information about it? Thanks, Peter Peter Conrad Staff Technical Writer: Infrastructure | salesforce.com Office: (415) 471-5265 [image:

Re: Comprehensive Guide for EXPLAIN

Hi Bernard, No, unfortunately there's no documentation for our explain plan (PHOENIX-1481). In your example, it's not fetching everything from the server. If it fetches everything from the server it would say "FULL TABLE SCAN". In this case, it's doing a "RANGE SCAN" between these two key ranges:

Comprehensive Guide for EXPLAIN

Hi, I know explain statement results are relatively easy to understand but is there a comprehensive guide for it? 0: jdbc:phoenix:localhost> explain select count(1) from test.table where insert_ts > now() - 30; *+--+* *| ** PLAN