On 4/17/06, chetana bhargav <[EMAIL PROTECTED]> 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.
