Re: create index right after create table not working?

On Sun, 16 Mar 2003 00:53:32 +0100, Joost Witteveen
<joostje@komputilo.org> wrote:
>Can CREATE index commands be issued right after the CREATE TABLE?

Yes.  And the index will be used if you do ANALYSE yourtable; or even
better VACUUM ANALYSE yourtable; after you have initially loaded your
table and before you start querying it.

ServusManfred