[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sqlite-users
Subject:    Re: [sqlite] CREATE INDEX
From:       Richard Hipp <drh () sqlite ! org>
Date:       2011-12-28 20:33:20
Message-ID: CALwJ=Mzy_2bSUqq8xoBLcJV2PMHV2ASV36umYh08Zz+M+PWNsQ () mail ! gmail ! com
[Download RAW message or body]

On Wed, Dec 28, 2011 at 3:28 PM, Pete <pete@mollysrevenge.com> wrote:

> If I create an index for a column in a table with existing data in it, is
> the index automatically populated or do I have to use the REINDEX command?
> Thanks,
>
> Automatically populated.  No REINDEX required.



>  --
> Pete
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
D. Richard Hipp
drh@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[prev in list] [next in list] [prev in thread] [next in thread]