Re: what does "index map: N" mean?

This is very interesting. Sergey, is this engine-agnostic? I know that Falcon has sparse bitmap indexing (already?) but I did not know if other engines support the concept (if not, are we "emulating" it in the optimizer?)

Baron, which engine are you testing against?

On a related note, I have been testing performance regressions of subqueries in 5.2.6 (yes, I wrote regressions, not improvements...) and have noticed another EXPLAIN phrase:

"Using index condition"

Sergey, what does this mean?

For reference, see the bug report I filed here:

http://bugs.mysql.com/?id=30659

Thanks!

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related lists.mysql.com Links announce benchmarks bugs certification cluster commits dotnet gui-tools internals java maxdb myodbc mysql mysqldoc packagers perl plusplus replication win32 Request more information about Pantek

Jay

Baron Schwartz wrote:
> Hi,
>
> Sergey Petrunia wrote:

>> Hi!
>>
>> On 8/29/07, Baron Schwartz  wrote:
>>> Sometimes in EXPLAIN output, I see this in the Extra field:
>> ...
>>> explain select * from t1, t1 t2 where t1.y = 2 and t2.x between 7 and
>>> t1.y+0;
>>> id    select_type    table    type    possible_keys    key    
>>> key_len    ref    rows    Extra
>>> 1    SIMPLE    t1    ref    y    y    5    const    1    Using where
>>> 1    SIMPLE    t2    range    x    x    5    NULL    4    Range 
>>> checked for each record (index map: 0x1)
>>>
>>> I know what the rest of it means, but what does 0x1 mean?
>>
>> It is a bitmap of indexes which can be used by range/index_merge
>> access that is performed for each row combination of the preceding
>> tables.

-- 
MySQL Internals Mailing List
For list archives: 
http://lists.mysql.com/internals
To unsubscribe:    
http://lists.mysql.com/internals?unsub=lists@pantek.com