Hi,
I have use SYS(3054,11) to check the optimization. My SQL can be optimized using index F2. However, the joining table A with B take most of time to execute. The index of F1 for both tables are same.
Any way to optimized joing table?
since, it take 15 seconds to for 5000 records matched, may not be acceptable by user. Any ideas?
Thank you
I am not the most powerful man in this world.
I am not the worst man in this world either.
I just as same as all of you.
I still need to learn from my mistakes...