How to exploit MySQL index optimizations - Xaprb - The Diigo Meta page

• 15 Jan 12
  

  Russell Davis

  sql indexes

• 05 Jul 11
  

  emilchacko

  tech Bookmarks_Bar db

• 15 May 09
  

  Muhammad Aizat Abdul Rahman

  MYSQL

• 09 May 09
  

  Charleno Pires

  performance index innodb howto mysql programming myisam optimization tutorials article tuning comparison cluster

• 25 Jul 08
  

  razvanpop

  mysql optimization performance database index innodb tutorial

• 

  Charles Nadeau

  MySQL tuning optimization index

• 25 Apr 08
  

  Argus Panoptes

  mysql index

• 07 Apr 08
  

  Navneet Kumar

  index optimizations in innodb
  Covering indexes

  MySQL Optimization InnoDB Indexing Database-Design

  • The InnoDB storage engine creates a clustered index for every table.
  • Once a query navigates to the leaf node of a secondary index, it knows two things: the values it used to navigate the index, and the primary key values of that row in the table.
  • covering index
  • f the Extra column includes the text “Using index,” the optimization is being used.
  • put the columns in the WHERE clause first in the index, then add the columns named in the SELECT clause at the end, unless they are included in the primary key.
  • If you only select the columns you need, your query might be able to use one of the optimizations
  • you select every column and the query uses a secondary index, there’s no way to do that, and the query will have to wander around indexes finding the rows it needs, then do other operations to get the actual values from the rows.
  • InnoDB secondary indexes already contain all columns from the primary key

  6 more annotations...

• 04 Apr 07
  

  Matti Narkia

  I’ve written a lot recently about MySQL index and table structure, primary keys, surrogate keys, and related optimizations. In this article I’ll explain how MySQL’s index structures enable an extremely important query optimization, and how that diff

  Howto how-to exploit MySQL index optimizations optimization query database indexes guide tutorial imported delicious

• 15 Mar 07
  

  Carl Dunham

  mysql database programming

• 05 Mar 07
  

  Romuald du Song

  How to exploit MySQL index optimizations

  mysql optimization index innodb

• 06 Jul 06
  

  Di Ci

  mysql innodb

Would you like to comment?

Join Diigo for a free account, or sign in if you are already a member.