Payables and Cash Management - EBS (MOSC)

MOSC Banner

Need to improve a query which is taking longer time

edited Apr 6, 2021 4:00PM in Payables and Cash Management - EBS (MOSC) 2 commentsAnswered

Hi All,

we have the requirement like based on attribute (non index) column , need to filter the data. could any of you please help me to improve the performance

SELECT  MAX (gl_date)           FROM AP_INVOICES_ALL 

          WHERE    attribute_category = 'abc'

             AND attribute6 = 'rewer'

             AND source = 'fdsd'

Plan

SELECT STATEMENT ALL_ROWSCost: 435,203 Bytes: 36 Cardinality: 1 

2 SORT AGGREGATE Bytes: 36 Cardinality: 1 

1 TABLE ACCESS FULL TABLE AP.AP_INVOICES_ALL Cost: 435,203 Bytes: 36 Cardinality: 1  

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