slow select execution
From: Christian <cbortolin_at_skynet.be>
Date: 5 Oct 2001 15:22:15 -0700
Message-ID: <77db1649.0110051422.68fe50a0_at_posting.google.com>
Date: 5 Oct 2001 15:22:15 -0700
Message-ID: <77db1649.0110051422.68fe50a0_at_posting.google.com>
Hi
we launched the following select :
this select is executed in 0.02 seconds
the following select goes a lot slower (3 seconds ! ! !)
select * from fact.access_control where ac_inst_nm = '003670029' and
ac_obj_type = 256
we also tried (without a faster response) :
select * from fact.access_control where ac_obj_type = 256 and
ac_inst_nm = '003670029'
oracle 8.1.5
Can anyone give me some hints to get these answers as fast as with the
first select ?
Thanks
select * from fact.access_control wher ac_inst_nm = '003670029'
key on ac_inst_nm
key on ac_inst_nm, ac_xcb, ac_obj_type, ac_xxx
Christian Received on Sat Oct 06 2001 - 00:22:15 CEST