For tables that don't return metadata with describe, limit 0 is fastest. We haven't yet implemented a check yet for a false expression.
On Thu, Oct 23, 2014 at 4:42 PM, Norris Lee <[email protected]> wrote: > Hi, > > I have a question about getting column metadata in the most efficient > manner. > > Is it more efficient to use LIMIT 1 or WHERE 0=1? Or is there an even > better way? > Does Drill prune the query out completely if it recognizes a false > predicate? > > Thanks, > Norris >
