GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Need help to understand select_scan

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • 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.

    regards,

    Nasir Rafiq
Working...
X