title: How to decrease query execution time MySql
body: <p>this is my Mysql database view.</p>
  
  <pre><code> Create View viewschools As Select
    school.*,
    conference.conference_name,
    conference.division_id,
    division.division_level,
    facility.facility_address,
    GROUP_CONCAT(DISTINCT facility.facility_name) AS Athletic_Venue
  FROM school
    INNER JOIN conference
      ON school.conference_id = conference.conference_id
    INNER JOIN division
      ON conference.division_id = division.division_id
    LEFT OUTER JOIN schoolfacilitysport
      ON school.school_id = schoolfacilitysport.school_id
    LEFT OUTER JOIN facilitytosports
      ON schoolfacilitysport.facilitytosports_id = facilitytosports.facilitytosports_id
    LEFT OUTER JOIN facility
      ON facilitytosports.facility_id = facility.facility_id
      group by school.school_id
  </code></pre>
  
  <p>in database tables 20 thousands record now query execution time is 13 second then i open this view in database. Query execution time increase when search any school name with like operator. Please suggest any thing to decrease query execution time.</p>