SG-229 Pick Ticket - All Pick Tickets Dataspy contains select /*+ FIRST_ROWS */ that is raising the cost of query - HxGN EAM - Version 12.0 - Hexagon

HxGN EAM Resolved Issues for 2022

Language
English
Product
HxGN EAM
Search by Category
HxGN EAM Version
12

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