Hi Team,For our project i have developed an query which included three different flows based on order_TYPE_CODE mentioned in the queries. This means for each order_type_code three different queries each queries has more table joined and all three sql queries joined with union all .
I have written for the same as two sql queries union all .its taking 3 to 4 min of time for an order parameter .Iam attaching the both type queries .Can you please help on this to improve performance of any of approach? Its very big query and written in single BIp data model. This can be as separate bip for each order_type but in future the parameter will be passed based on time for which there will be more order numbers and each order will of diff order type code and it should pass in loop for each type sql queries based on order type which cant be done in bip.so written as single queries in single bip data model.Please help me on tuning the queries .This is oracle chrm project and all are oracle fusion tables so not sure about the indexes. Will be very much helpful if suggested. Attaching the queries since it is very big
rebill_two .sql
rebill_one.sql