indexes and views

suppose the following:

I have a table like

create table t1
(c1 number
,c2 number
,primary key (c1)
)
/

>From this table I create a view like

create view v1 as
select to_char(c1)||'.'||to_char(c2) c3
  from t1
/

Now of course, when I query v1 no index can be used. To create an index on c3 I would have to create a materlialized view. Or is there a way to utilize indexes defined on t1 for queries on v1? Can I create an index on t1 which supports queries on v1?

Thanks for all the input,
stephan Received on Thu Mar 10 2005 - 01:20:31 CST