SQL Performance (MOSC)

MOSC Banner

Need help to improve performance of a query

Hi All,

As per the requirement, need to retrieve the data based on non index column of a table. Table consists of million of records. 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'

Explain 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