What is the maximum no. of indexes per table???
We are on 126.96.36.199.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.
To handle yourself, use your head. To handle others, use your heart