asterixdb-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mike Carey <dtab...@gmail.com>
Subject Re: Indexes not performing well
Date Tue, 31 May 2016 05:16:47 GMT
Indeed - the missing hint info was indeed, e.g.:   ...  $emp.fname /*+ 
skip-index */ >= "Max"  ...

(Our hints are essentially "optimizer interpreted comments" that start 
with a + to get its attention; it ignores hints it doesn't understand or 
that do not apply, so it's good to verify that they're taken by looking 
at the resulting plans.)


On 5/30/16 10:11 PM, Taewoo Kim wrote:
>   $emp.fname /*+ skip-index */ >= "Max"


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message