Thanks for the info.
Cheers,
Chetana.
Jay Sprenkle <[EMAIL PROTECTED]> wrote:
On 4/17/06, chetana bhargav wrote:
> Am I correct in saying that once we create an index on a table what ever the
> new records added would be done according to the index mentioned.
>
> If so, if we create an index on a table which has already some records then
> will those records be re-arranged.
Records are not reordered or moved based on the index.
The index is like an index in a book. It tells where to find things but doesn't
change the order.
---------------------------------
How low will we go? Check out Yahoo! Messengers low PC-to-Phone call rates.
