Index on view?

Oracle 8x
I have read only access to some views and not to corresponding tables. I have some queries like
select a from view1 where c = 'xyz' and d in ('abc','def');
This is taking lot of time. I feel if there are indexes on fields 'c' and 'd' on corresponding table it would be faster. Is this right? If we create index on tables and we access views would it be faster? Or can we create index on views also? Any tips to improve performance

Try trouble shooting the problem by looking at the explain plan. you could use hints too.. also I would and executing the query with one where clause (ie first with only 'where c = ...' there by making sure which fields you might need to create an index. Indexing should definately help, also home many records are we talking here. if there are not a lot indexing might not make a big difference. As far as creating indexes in views i dont think you could do that, but I am not 100% positive. some googling might help on that one.

Jiggee