>Do i need to create appropriate indexes on the ORACLE tables?

You don't privde much info but...in general put an index on any table.column that you use in a where clause that has over 20% of the values different from each other..

Otherwise you can use a bitmap index.

What's RI?