explain analyze SELECT audit , store , question , month , year , week , weekday , myaudittotalscore , active , auditnum , answer , quarter , y_n , region , district , audittype , status , keyedby , questiondisplay , qtext , qdescr , answerdisplay , answertext , customauditnum , dateaudittaken , datecompleted , dateauditkeyed , datekeyingcomplete , section , createdby , division , auditscoredesc , locationnum , text_response , Sum(questionpointsavailable) , Sum(pointsscored) from viwAuditCube where clientnum ='RSI' GROUP BY audit, store, question, month, year, week, weekday, myaudittotalscore, active, auditnum, answer, quarter, y_n, region, district, audittype, status, keyedby, questiondisplay, qtext, qdescr, answerdisplay, answertext, customauditnum, dateaudittaken, datecompleted, dateauditkeyed, datekeyingcomplete, section, createdby, division, auditscoredesc, locationnum, text_response ORDER BY audit, store, question, month, year, week, weekday, myaudittotalscore, active, auditnum, answer, quarter, y_n, region, district, audittype, status, keyedby, questiondisplay, qtext, qdescr, answerdisplay, answertext, customauditnum, dateaudittaken, datecompleted, dateauditkeyed, datekeyingcomplete, section, createdby, division, auditscoredesc, locationnum, text_response
Joel Fradkin
Wazagua, Inc.
[EMAIL PROTECTED]
|