Re: Bulk Insert and Index use

In an attempt to throw the authorities off his trail, tech(at)wildcash(dot)com (Rudi Starcevic) transmitted:
> A minute for your thoughts and/or suggestions would be great.

Could you give a more concrete example? E.g. - the DDL for the
table(s), most particularly.

At first guess, I think you're worrying about a nonissue. Each insert
will lead to a _modification_ of the various indices, which costs
_something_, but which is WAY less expensive than creating each index
from scratch.

But perhaps I'm misreading things; DDL for the intended tables and
indices would be real handy.
--
output = ("cbbrowne" "@" "cbbrowne.com")
http://www.ntlug.org/~cbbrowne/linux.html
Rules of the Evil Overlord #21. "I will hire a talented fashion
designer to create original uniforms for my Legions of Terror, as
opposed to some cheap knock-offs that make them look like Nazi
stormtroopers, Roman footsoldiers, or savage Mongol hordes. All were
eventually defeated and I want my troops to have a more positive
mind-set." <http://www.eviloverlord.com/>