>>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?
RI is short for Referential Integrity.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)