Yes, you are right we have lots of one to many relationships in our tables(fields in table). Well, there is not much I can do to change the design.. .............
Is there any document which will explain repercations of using one- many relationships in a table (for my reference).
Is it true that indexes won't be used if I have DECODE in where clause ??

Thanks again
Sonali