SG-229 Pick Ticket - All Pick Tickets Dataspy contains select /*+ FIRST_ROWS */ that is raising the cost of query |
Description |
|
the Pick Ticket default function dataspy is starting with /*+ FIRST_ROWS */ this actually raising the cost of query and should be removed (From MT Cloud DBA suggestion) select /*+ FIRST_ROWS */ s.str_org storeorg,p.pic_status pickticketstatus,p.pic_code pickticketnum,p.pic_desc description,p.pic_store store,r5o7.o7get_desc('IT','UCOD', p.pic_status,'PLST', '') pickticketstatus_display,p.pic_required daterequired,p.pic_class class,p.pic_event workorder,COALESCE(act_parent, act_act) activity,p.pic_object equipment,p.pic_deladdress deladdress,p.pic_supplier supplier,p.pic_person toemployee,p.pic_origin originator,p.pic_dfltauth defaultapprover,p.pic_auth approvedby,p.pic_approv dateapproved,SQL_986.prv_dvalue c_p_idataco_pick from r5stores s, r5userorganization, r5permissions, r5picklists p LEFT OUTER JOIN r5activities ON (act_event = p.pic_event AND act_act = p.pic_act) LEFT OUTER JOIN r5propertyvalues SQL_986 on pic_code=SQL_986.prv_code and SQL_986.prv_rentity = 'PICK' and SQL_986.prv_property='P-DATACO' where p.pic_store = s.str_code AND uog_user = ' ' AND uog_role = '*' and uog_org=s.str_org AND uog_group = prm_group AND prm_select = '?' AND prm_function ='SSPICK' order by p.pic_code ASC *Steps to reproduce:* # Go to customer MT Cloud environment PRD # Login with the specific user # Go to all Pick tickets default dataspy # Hit the maximum score |