Originally posted by rajabalachandra
if the data and index are on different
spindle it will increase the performance.
You're guessing -- this is not the way Oracle works. Index and table access do not occur simultaneously.

Time to think again, 'cos this is a myth that needs to die.