||Hi Vince Angelo,
Thanks for your prompt response. Actually all the tablespaces in the database are in the same disk and by moving the indexes, i would like to see any performance improvement. As per your message, it states that it won't improve the performance if the large file exists on the same disk. What other alternatives best suitable in this case to improve the performace ?