Depuration process to XOM ORDER_HISTORY table OROBv15 Database
Hi Gurus.
Can you help us with the following doubt please? we are facing performance issue on Order Broker DB when we did selects to XOM_ORDER_HISTORY table, rigth now we have more than 26 millions records on it and we want to know two things.
1.- 26 millions of record is enough information to increase load DB and provoke perfomance issue ?
a) recently we are detected the following selec instrucction on that table that provoke sever perfomance issue on DB, it the folowing:
SELECT LOCATION.LOCATION_ID AS LOCATION_ID , MAX(ACTIVITY_DATE) AS ACTIVITY_DATE
FROM XOM_STATUS_HISTORY