Hi all,

We are on 8.1.7.3.0/ Win2K using Oracle Apps. We have done lot of customization in Apps resulting performance problems because in custom queries, developers/designers have used Substr, upper and other functions in the Where clause due to which, indexes are not being used on most of the queries and this leads to FTS. I have created function based indexes whereever felt required.

But, I have following questions/doubts.

1. Can I just go on creating indexes where table is being queried without using indexes?
2. Will it not create any performance issues?
3. Is there a maximum limit on having no. of indexes per table?

Please help me understand the above.

Thanks in Adv.