Web Analytics Made Easy -
StatCounter use indexes? - CodingForum


No announcement yet.

use indexes?

  • Filter
  • Time
  • Show
Clear All
new posts

  • use indexes?

    Hi there.....my table has some indexes declared. How i can use them in the select queries in order to achieve better performance?

  • #2
    Short functional answer : They are used automatically if possible.
    Tech answer : when you run a select, the RDBM will first read the tables schema. If it finds an index there that can be used to filter on one of the used columns, or that is used to optimise a function or clause (like LIMIT), then it will automatically use that index to select the relevant datapages and will then perform a seek on each selected datapage.
    Full functional answer : http://www.mysql.com/doc/en/MySQL_indexes.html
    Posting guidelines I use to see if I will spend time to answer your question : http://www.catb.org/~esr/faqs/smart-questions.html