Re: [Maria-developers] [Commits] Rev 2994: Original idea from Zardosht Kasheff to add HA_CLUSTERED_INDEX in lp:maria/5.3

2011-05-19 Thread Sergei Golubchik
Hi, Michael! On May 18, Michael Widenius wrote: === modified file 'sql/handler.h' --- a/sql/handler.h 2011-05-16 11:05:45 + +++ b/sql/handler.h 2011-05-18 16:26:30 + @@ -161,8 +161,11 @@ */ #define HA_KEY_SCAN_NOT_ROR 128 #define HA_DO_INDEX_COND_PUSHDOWN 256 /*

Re: [Maria-developers] [Commits] Rev 2994: Original idea from Zardosht Kasheff to add HA_CLUSTERED_INDEX in lp:maria/5.3

2011-05-19 Thread Michael Widenius
Hi! Sergei == Sergei Golubchik s...@askmonty.org writes: cut + Data is clustered on this key. This means that when you read the key + you also get the row data in the same block. Sergei perhaps, better to say that you get the row data without an extra seek Sergei (or even without an

Re: [Maria-developers] [Commits] Rev 2994: Original idea from Zardosht Kasheff to add HA_CLUSTERED_INDEX in lp:maria/5.3

2011-05-19 Thread Sergei Golubchik
Hi, Michael! On May 19, Michael Widenius wrote: +++ b/sql/sql_select.cc2011-05-18 16:26:30 + @@ -16525,9 +16527,9 @@ test_if_skip_sort_order(JOIN_TAB *tab,OR */ DBUG_ASSERT (ref_key != (int) nr); -bool is_covering= table-covering_keys.is_set(nr) || -