Hello,
I am looking to seek help on sql performance issue regarding joining of 6 tables.
I have a commercial with rowcount of 44.5K
campaign 78K
product 14K
product_commercial 49K
and two region tables which have only 3 rows in each.
One of the where conditions is to bring back rows for a 'IRE' region and the other clause is for a date range.
product code is an indexed column for all apart from the two region tables.
Any direction as to which direction to approach this multi join/table query for best performance before I run an explain plan??
Would I be best to use other then an sql query....i.e. would I be better to run a cusror within a plsql block, use a function, OOoptions??
Rgds,,,
I am looking to seek help on sql performance issue regarding joining of 6 tables.
I have a commercial with rowcount of 44.5K
campaign 78K
product 14K
product_commercial 49K
and two region tables which have only 3 rows in each.
One of the where conditions is to bring back rows for a 'IRE' region and the other clause is for a date range.
product code is an indexed column for all apart from the two region tables.
Any direction as to which direction to approach this multi join/table query for best performance before I run an explain plan??
Would I be best to use other then an sql query....i.e. would I be better to run a cusror within a plsql block, use a function, OOoptions??
Rgds,,,
