SQL Performance (MOSC)

MOSC Banner

optimizing select statement

edited Feb 4, 2020 12:50AM in SQL Performance (MOSC) 5 commentsAnswered

Dear friends,

As stated on topic, could someone guide me how to improve this select statement please ?

SELECT ENTITY_EVENT_ID,

       LAST_SR_STATUS,

       LAST_SR_STATUS_CHECK,

       VENDOR,

       LAST_SR_UPDATE,

       PROD_ID,

       EXTERNAL_SYSTEM_ID,

       MESSAGE_CODE,

       UPDATED,

       LATEST_UPDATE,

       MAX_INACTIVE_MSECS,

       CASE_STATE_ID,

       LATEST_SYMPTOM,

       ABLE_CASE_INCIDENT,

       MAX_URGENCY,

       AGGREGATED_INCIDENTS,

       REPORTED_AGG_NF,

       REPORTED_AGGREGATES,

       LAST_REPORTED_AGG_NF,

       NEXT_REPORT_AFTER,

       NEXT_REPORT_AGG_NF,

       REPEATED_CLOSURE_ID,

       NEXT_EXPIRATION,

       EXTERNAL_SR_NUMBER,

       NEXT_CLOSE,

       PRODUCT,

       RECOMMENDED_ACTION,

       CURRENT_STARTING,

       CUST_DELIVERY_ID,

       EXTERNAL_EVENT_ID,

       EXTRA_EVENT_DATA,

       PRIOR_AGGREGATES,

       AUTO_CLOSE_CASE,

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