Subject | Re: [firebird-support] Rebuilding primary key index? |
---|---|
Author | Kjell Rilbe |
Post date | 2010-11-09T19:52:25Z |
Leyne, Sean skriver:
sequentially, in random order or whatever?
Kjell
--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64
> > But you didn't ask my main question: what would you recommend that I doSo, no need to rebuild any indexes regardless of items being added
> > with the indexes after importing this rather huge amount of data,
> starting
> > with a completely empty database?
>
> All you should need to do is perform " SET STATISTICS INDEX {Index
> Name}" for all non-unique indexes.
sequentially, in random order or whatever?
Kjell
--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64