Need help to understand select_scan

  • Filter
  • Time
  • Show
Clear All
new posts

  • Need help to understand select_scan

    Hi Guys,

    I am new to MySQL and i have to analyze and reduce the value of select_scan status variable for a large web application. but i don't have a deep knowledge about these select_scan.

    i just know that it is incremented whenever a full table scan is done on the first table used in a join. But i am not sure about how can i reduce this and what can be an acceptable value for a large application. Currently it averages to 43000 per day.

    The application uses Hibernate and all the queries are generated by hibernate.

    Can anyone kindly explain these select_scan to me and help me out that how to reduce the number. will indexing be of any help for this.

    any help will be appreciated deeply.


    Nasir Rafiq