Re: problems accessing an index when using a variable inlist
- From: "jaromir nemec" <jaromir@xxxxxxxxxxxx>
- To: <ryan_gaffuri@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 29 Nov 2007 19:27:51 +0100
Hi Ryan,
one possible reason is that the cardinality of the IN-LIST table is wrongly
estimated.
You may verify it using the cardinality hint in the "select * from table",
setting the cardinality to the length of your IN-LIST.
Regards,
Jaromir
----- Original Message -----
From: <ryan_gaffuri@xxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Thursday, November 29, 2007 5:27 PM
Subject: problems accessing an index when using a variable inlist
I am using the standard variable inlist code from asktom. I find that when
I use it, I cannot access an index.
WHERE a.col1 IN (select * from table( select cast(
k_utility.func_varchar_in_list(col1) as
t_varchar_tab ) from dual a))
--
//www.freelists.org/webpage/oracle-l
Other related posts:
