Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> When is an index created?

When is an index created?

From: Brian Tkatch <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK>
Date: Tue, 19 Sep 2000 21:40:24 GMT
Message-ID: <39c7dcae.17078625@news.alt.net> 






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.



Brian
Received on Tue Sep 19 2000 - 16:40:24 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US