Retail Point-of-Service Solutions (MOSC)

MOSC Banner

Performance issue in SQL queries

edited Mar 28, 2014 12:00PM in Retail Point-of-Service Solutions (MOSC) 2 commentsAnswered

Hi All,

I have developed a utility to get the transaction data from POS in to a .csv file using Java and SQL queries.

This jar is taking 5 hrs in production to execute and generate the file, whereas in local environment its taking 20 min.

I figured out that this is an indexes problem, but due to some reasons creating indexes on Production is not possible, so I am trying to optimize my queries.

Please help me, to optimize and I have written to my best.

Please find one the query below.

SELECT DISTINCT trn.ID_STR_RT,

  trn.ID_WS,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center