为什么BrioQuery比SQL慢很多(十几倍，几十倍）？

[lozoo]

Brio Query 通过sql*net 查询OracleApp数据库,双表连接， 很慢. 通过File--> Export to SQL ，在SQL Plus或其他查询软件中查询很快。为什么？有办法提高Brio 查询速度吗？

/* Formatted on 2005/05/23 10:57 (Formatter Plus v4.8.5) */
SELECT al1.segment1, al1.description, al2.acct_period_id, al2.actual_cost,
al2.attribute_category, al2.attribute1, al2.attribute10,
al2.attribute11, al2.attribute12, al2.attribute13, al2.attribute14,
al2.attribute15, al2.attribute2, al2.attribute3, al2.attribute4,
al2.attribute5, al2.attribute6, al2.attribute7, al2.attribute8,
al2.attribute9, al2.completion_transaction_id, al2.cost_group_id,
al2.cost_update_id, al2.costed_flag, al2.created_by, al2.creation_date,
al2.currency_code, al2.currency_conversion_date,
al2.currency_conversion_rate, al2.currency_conversion_type,
al2.cycle_count_id, al2.department_id, al2.distribution_account_id,
al2.employee_code, al2.encumbrance_account, al2.encumbrance_amount,
al2.ERROR_CODE, al2.error_explanation, al2.expenditure_type,
al2.final_completion_flag, al2.flow_schedule, al2.freight_code,
al2.inventory_item_id, al2.invoiced_flag, al2.last_update_date,
al2.last_update_login, al2.last_updated_by, al2.locator_id,
al2.master_schedule_update_code, al2.material_account,
al2.material_overhead_account, al2.move_transaction_id,
al2.movement_id, al2.new_cost, al2.number_of_containers,
al2.operation_seq_num, al2.organization_id,
al2.outside_processing_account, al2.overhead_account,
al2.pa_expenditure_org_id, al2.percentage_change,
al2.physical_adjustment_id, al2.picking_line_id, al2.pm_cost_collected,
al2.pm_cost_collector_group_id, al2.primary_quantity, al2.prior_cost,
al2.prior_costed_quantity, al2.program_application_id, al2.program_id,
al2.program_update_date, al2.project_id, al2.quantity_adjusted,
al2.rcv_transaction_id, al2.reason_id, al2.receiving_document,
al2.repetitive_line_id, al2.request_id, al2.resource_account,
al2.revision, al2.rma_line_id, al2.shipment_costed,
al2.shipment_number, al2.source_code, al2.source_line_id,
al2.source_project_id, al2.source_task_id, al2.subinventory_code,
al2.task_id, al2.to_project_id, al2.to_task_id,
al2.transaction_action_id, al2.transaction_cost, al2.transaction_date,
al2.transaction_group_id, al2.transaction_id, al2.transaction_quantity,
al2.transaction_reference, al2.transaction_set_id,
al2.transaction_source_id, al2.transaction_source_name,
al2.transaction_source_type_id, al2.transaction_type_id,
al2.transaction_uom, al2.transfer_cost, al2.transfer_cost_dist_account,
al2.transfer_cost_group_id, al2.transfer_locator_id,
al2.transfer_organization_id, al2.transfer_percentage,
al2.transfer_prior_costed_quantity, al2.transfer_subinventory,
al2.transfer_transaction_id, al2.transportation_cost,
al2.transportation_dist_account, al2.trx_source_delivery_id,
al2.trx_source_line_id, al2.ussgl_transaction_code, al2.value_change,
al2.variance_amount, al2.vendor_lot_number, al2.waybill_airbill
FROM apps.mtl_system_items al1, inv.mtl_material_transactions al2
WHERE (al1.inventory_item_id = al2.inventory_item_id)
AND ( al2.subinventory_code = 'BEST'
AND al2.transfer_subinventory LIKE '7%'
AND al2.organization_id = 672
AND al2.transaction_date >= to_date('2005-05-21 00:00:00','YYYY-MM-DD HH24:MI:SS')
AND al1.organization_id = 672
)

注：Export出来时，时间是‘2005-05-21’在SQL中我改成了to_date('2005-05-21 00:00:00','YYYY-MM-DD HH24:MI:SS'). 将这里的Where语句拷到Brio的Custom SQL中查询还是慢！