Amount of segments per tablespace

[rajabalachandra]

hi,

if the data and index are on different
spindle it will increase the performance.

obviously it should be in different datafiles.
same tablespace or different tablespace no matter.

if it is in same tablespace there is a chance
of allocating into the same datafile unless
you preallocate the space in a different datafile.

if it is in different tablespace need not worry.

-Raja