Re: When is an index created?

Brian Tkatch <SPAMBLOCK.Maxwell_Smart_at_thepentagon.com.spamblock> wrote:
: When I create an index on a table, it says index created just a moment
: afterwards. Is it really that quick or is the index created later.
 

: CREATE INDEX A ON Table(LOWER(Text));
 

: The table had over 20,000 records.

        Index is really created immediately.  

My system on small table 111843 sorts (rows) in 111843 sorts (rows)

        Starous Received on Wed Sep 20 2000 - 00:00:00 CDT