List:Falcon Storage Engine« Previous MessageNext Message »
From:Lars-Erik Bjørk Date:October 22 2008 6:51pm
Subject:Re: Non-indexed selections
View as plain text  
Hi Ann!

Thanks for the explanation, I was wondering because I am able to  
reproduce bug#34479, that we discussed on the Friday conf. call even  
without adding indexes to the field.

/Lars-Erik

On Oct 22, 2008, at 6:40 PM, Ann W. Harrison wrote:

> Lars-Eric,
>
>   You asked on IRC about non-indexed selection criteria.  For our
> first release, we don't handle them at all.  We return all rows and
> the server does the filtering.  The server is capable of passing
> non-indexed conditions to the engines - NDB for one uses that - but
> it really doesn't save very much for an in-process engine.  At
> some point, the work that Timour is doing may let the server pass
> multiple indexed conditions to the server (e.g.
>
>   select order_amount from orders
>     where customer_id = 25 and order_date = '22 Oct 2008'
>
> when both order_date and customer_id are indexed).  When that
> is possible, Falcon can use logically combine the bitmaps for
> the two indexes and retrieve only rows where both conditions
> are satisfied.
>
>   But for now, all we do is lookups on a single index or return
> the whole table.
>
>
> Cheers,
>
>
> Ann
>
> -- 
> Falcon Storage Engine Mailing List
> For list archives: http://lists.mysql.com/falcon
> To unsubscribe:    http://lists.mysql.com/falcon?unsub=1
>

Thread
Non-indexed selectionsAnn W. Harrison22 Oct
  • Re: Non-indexed selectionsLars-Erik Bjørk22 Oct
    • Re: Non-indexed selectionsAnn W. Harrison22 Oct
      • Re: Non-indexed selectionsLars-Erik Bjørk23 Oct