Is there any wizard for sql query tuning?

Hi,
I have a query to be tuned. Do we have a wizard for doing this? the
query is:
SELECT mmt.transaction_id Transaction_ID,
mtt.transaction_type_name Transaction_Type,
msib.segment1 Item_Number,
mut.serial_number Serial_Number,
ccg.cost_group Cost_Group,
mmt.subinventory_code Sub_Inventory,
mil.segment1||'.'||
mil.segment2||'.'||
mil.segment3||'.'||
mil.segment4||'.'||
mil.segment5 Locator,
mmt.transaction_quantity Transaction_Quantity,
mmt.transaction_date Transaction_Date_Time,
TO_CHAR(ooha.order_number) Source_Number
FROM apps.mtl_material_transactions mmt ,
apps.mtl_transaction_types mtt ,
apps.mtl_system_items_b msib,
apps.mtl_unit_transactions mut ,
apps.cst_cost_groups ccg ,
apps.mtl_item_locations mil ,
apps.oe_order_headers_all ooha,
apps.oe_order_lines_all oola
WHERE mtt.transaction_type_id = mmt.transaction_type_id
AND msib.inventory_item_id = mmt.inventory_item_id
AND mmt.organization_id = msib.organization_id
AND mut.transaction_id = mmt.transaction_id
AND ccg.cost_group_id = mmt.cost_group_id
AND mmt.locator_id = mil.inventory_location_id
AND mmt.trx_source_line_id = oola.line_id(+)
AND ooha.header_id(+) = oola.header_id;
Can any Oracle ghuru help me in tuning this query plz...
Regds,
Abhishek
*** Sent via Developersdex http://www.examnotes.net ***> Can any Oracle ghuru help me in tuning this query plz...
I'm afraid here can help you only SQL Server ghuru, sorry!
"Abhishek Gupta" <abhigupta008@.gmail.com> wrote in message
news:eJqKjx8SFHA.2768@.tk2msftngp13.phx.gbl...
> Hi,
> I have a query to be tuned. Do we have a wizard for doing this? the
> query is:
> SELECT mmt.transaction_id Transaction_ID,
> mtt.transaction_type_name Transaction_Type,
> msib.segment1 Item_Number,
> mut.serial_number Serial_Number,
> ccg.cost_group Cost_Group,
> mmt.subinventory_code Sub_Inventory,
> mil.segment1||'.'||
> mil.segment2||'.'||
> mil.segment3||'.'||
> mil.segment4||'.'||
> mil.segment5 Locator,
> mmt.transaction_quantity Transaction_Quantity,
> mmt.transaction_date Transaction_Date_Time,
> TO_CHAR(ooha.order_number) Source_Number
> FROM apps.mtl_material_transactions mmt ,
> apps.mtl_transaction_types mtt ,
> apps.mtl_system_items_b msib,
> apps.mtl_unit_transactions mut ,
> apps.cst_cost_groups ccg ,
> apps.mtl_item_locations mil ,
> apps.oe_order_headers_all ooha,
> apps.oe_order_lines_all oola
> WHERE mtt.transaction_type_id = mmt.transaction_type_id
> AND msib.inventory_item_id = mmt.inventory_item_id
> AND mmt.organization_id = msib.organization_id
> AND mut.transaction_id = mmt.transaction_id
> AND ccg.cost_group_id = mmt.cost_group_id
> AND mmt.locator_id = mil.inventory_location_id
> AND mmt.trx_source_line_id = oola.line_id(+)
> AND ooha.header_id(+) = oola.header_id;
> Can any Oracle ghuru help me in tuning this query plz...
> Regds,
> Abhishek
> *** Sent via Developersdex http://www.examnotes.net ***|||Why are you posting an Oracle question to a SQL Server group? Try one
of the Oracle groups such as:
comp.databases.oracle.server
comp.databases.oracle.misc
comp.databases.oracle.tools
http://groups-beta.google.com/groups/dir?q=oracle
David Portas
SQL Server MVP
--