Do indexes in Appliation Designer and Oracle need to be in SYNC?
This is a very basic question but I still need assistance on it....The query that we run in PeopleSoft will anyway execute on Oracle....So, why create an index in application designer? I can only create indexes in Oracle and run peoplesoft processes....
Can you please explain the loop hole in the above comment?