Subject Re: [firebird-support] Does added column cause all records to be touched or what happens?
Author Kjell Rilbe
Ann W. Harrison skriver:
> What's taking the time is creating an index on 150,000,000 records
> all of which have exactly the same key value. I seriously doubt
> that the index will be of any value to you, and now that it's created,
> it will have a selectivity of 1.0 - as bad as it gets. When you do
> put values in that field, you should at least reset the selectivity.
> Though it sounds unkind, given how much work Firebird has put into
> creating a worthless index, I suggest you drop it and recreate it
> when you've actually got more than one value.

Yes, I realized that once it had started executing - that the index
should have been created a bit later in the process. Oh, well... It will
get a lot more selective later on, I promise! ;-)

Thank you for answering!

Kjell Rilbe
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64