lp:~laurynas-biveinis/percona-server/tokudb-clustering-query-opt

Created by Laurynas Biveinis on 2014-01-23 and last modified on 2014-03-26
Get this branch:
bzr branch lp:~laurynas-biveinis/percona-server/tokudb-clustering-query-opt
Only Laurynas Biveinis can upload to this branch. If you are Laurynas Biveinis please log in for upload directions.

Branch merges

Related bugs

Related blueprints

Branch information

Owner:
Laurynas Biveinis
Project:
Percona Server
Status:
Merged

Recent revisions

569. By Laurynas Biveinis on 2014-03-26

Add secondary clustering key support to selected places in the query optimizer,
https://blueprints.launchpad.net/percona-server/+spec/multiple-clustering-keys-query-opt.

- Declare new index flag HA_CLUSTERED_INDEX, which a storage engine is
  supposed to return in index_flags() for any secondary clustered
  index.

- Make find_shortest_key() not to prefer the primary over a secondary
  key indexing all table columns if the secondary key is clustering.

- Modify Optimize_table_order::best_access_path() to treat secondary
  clustering keys as covering keys (no row read required) for access
  time estimates.

- In make_join_readinfo(), consider secondary clustering keys for the
  join if no suitable covering keys and before resorting to table
  scan.

- In test_if_skip_sort_order(), skip sorting for secondary clustered
  keys too.

- In test_if_cheaper_ordering(), treat secondary clustered keys as
  covering keys.

568. By Laurynas Biveinis on 2014-03-26

Automerge prerequisite branch

Branch metadata

Branch format:
Branch format 7
Repository format:
Bazaar repository format 2a (needs bzr 1.16 or later)
Stacked on:
lp:percona-server/5.6
This branch contains Public information 
Everyone can see this information.