How to pass bind variable value into a view
Date: Thu, 8 Oct 2009 11:54:54 -0700 (PDT)
RDBMS : 188.8.131.52 I have the following query:
select * from v1 where v1_col1=:BIND_VAR
v1 is a view:
create view v1
select t1.col1, t2.col2 from t1,t2
t1.col1 - unique index,
t2.col2 - non unique index.
select * from v1 where v1.col1=?
takes about 60sec to execute.
select * from ( select t1.col1, t2.col2 from t1,t2
takes 1 sec to execute.
mainly here rowsource is reduced when t1.col1 is taken alongwith inner query.
- Is there any way we can pass bind variable to the inner query with using view v1 ( i know BIND var cannot be passed to DDL)but any other way you would suggest to achieve the same result.
Regards Received on Thu Oct 08 2009 - 13:54:54 CDT