phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Taylor <>
Subject Re: Explain Plan - Full scan vs Skip scan
Date Fri, 23 Jun 2017 00:01:22 GMT
Hi Michael,
Would it be possible for you to provide an example with DDL, query, and
explain plan?

On Fri, Jun 23, 2017 at 2:36 AM Mike Prendergast <>

> We are currently using Phoenix 4.9 in EMR 5.6. We have been constructing
> queries that we would expect the explain plan to describe as either skip
> scan or range scan queries. Instead, it returns 1-way round robin full
> scans in the plan output.
> However, when we execute the queries, Phoenix does not throw an error like
> with a Full scan and instead executes the query and responds quickly as we
> would expect them to since they are built to be very tight scans. Is there
> a reason why the Explain plan output seems misleading? Thanks in advance
> Michael Prendergast
> *iota IT*
> Vice President / Software Engineer
> (cell)     703.594.1053
> (office)  571.386.4682
> (fax)     571.386.4681
> This e-mail and any attachments to it are intended only for the identified
> recipient(s). It may contain proprietary or otherwise legally protected
> information of Iota IT, Inc. Any unauthorized distribution, use or
> disclosure of this communication is strictly prohibited. If you have
> received this communication in error, please notify the sender and delete
> or otherwise destroy the e-mail and all attachments immediately.

View raw message