Posted 21 Days Ago Job ID: 1569583 1 quotes received

MySQL

Fixed Price or Hourly
Quotes (1)  ·  Premium Quotes (0)  ·  Invited (1)  ·  Hired (0)

  Send before: August 26, 2019

Send a Quote

Programming & Dev Database Design & Administration

i need an analysis of this query and atleast 3 optional ways the quesry could be written for better execution time 

Select SQL_CALC_FOUND_ROWS 
-- uuidfrombin(e.id) as id,
e.currentState,
e.entryType,
COALESCE(e.deferScheduledDate, e.scheduledDate) as scheduledDate,
e.scheduledDate,
e.amount,
e.sch ... Show more
Manny D United States