Oracle and SQR
From: Joseph S. Testa <teci_at_oracle-dba.com>
Date: Wed, 22 Jul 1998 21:54:04 -0400
Message-ID: <35B697BC.5B43D40A_at_oracle-dba.com>
AM helping some developers tune some SQR stuff. The sql (based on trace/tkprof info) is using bind variables, so hence, the selectivity is not known and oracle can't determine is an index should be used or not, so full table scans are being done. In the non-sqr world, just place a hint(we are using CBO) and all works well.
Date: Wed, 22 Jul 1998 21:54:04 -0400
Message-ID: <35B697BC.5B43D40A_at_oracle-dba.com>
AM helping some developers tune some SQR stuff. The sql (based on trace/tkprof info) is using bind variables, so hence, the selectivity is not known and oracle can't determine is an index should be used or not, so full table scans are being done. In the non-sqr world, just place a hint(we are using CBO) and all works well.
Does anyone know if in SQR an oracle hint can be placed inline with the sql, we are getting syntax errors when we try it. Has anyone successfully places hints in sqr program???
thanks, joe
http://www.oracle-dba.com
-- Joseph S. Testa, Oracle Database Administrator Vice-President Ohio Oracle Users Group, http://www.ooug.org OOUG welcomes Steven Feuerstein to Columbus OH in Oct, if your company is interested in becoming a corporate sponsor for this event, send mailto:vice_pres_at_ooug.org. Want some remote DBA work done? mailto:teci_at_oracle-dba.com ICQ http://wwp.mirabilis.com/2832230Received on Thu Jul 23 1998 - 03:54:04 CEST