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.
Jay Sprenkle <[EMAIL PROTECTED]> wrote:
On 4/17/06, chetana bhargav wrote:
> I just want to know, if we create an index on any table, how the index is
> stored, is it stored in a seperate file or as part of the current table only
> in the same file.
There's only one file no matter how many tables or indexes you create.
---------------------------------
Love cheap thrills? Enjoy PC-to-Phone calls to 30+ countries for just 2ยข/min
with Yahoo! Messenger with Voice.
