Re: Bad performance caused by DISTINCT?
I would suggest you to create composite index of following fields
alter table <tablke_name> add index (retailer_id, year_for_reports, month_for_reports, date_time );
Hope this will help you.
Regards,
Yogesh Salvi
Subject
Views
Written By
Posted
8563
November 13, 2006 02:02PM
4403
November 19, 2006 09:29PM
Re: Bad performance caused by DISTINCT?
3433
December 13, 2006 04:46AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.