If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Query Tuning

Hi,
Can any one guide me on how to tune this query for
optimal performance.The query and my explain plan are
as stated below.Is there any other alternative for me
to tune this query to get better performance
benefits.Say lower the cost.And faster time.Your suggestions are
greatly appreciated.

Are there any Indexes on the table ?
If not, you can create Global/Local Prefixed/Non-Prefixed Indexes on the table, in order to improve table access.

Prefixed Local Index - The index key is identical to the partitioning key.
Non-Prefixed Local Index - The index key is not identical to partitioning key.
Global Prefixed Index - The index key is identical to the partitioning key, but allows different partitioning from that of the underlying table.

Identify the candidate columns for indexes and create proper indexes on the partitioned tables.

Cheers.

It is better to ask and appear ignorant, than to remain silent and remain ignorant.

Whether or not you need to do a full table scan accross your partitions depends on whether you are selecting results from more than one partition as well as what local and global indexes you have. Since I don't know either this is my suggestion.