| Subject | Re: [ib-support] Will unique index of long field hurt speed? |
|---|---|
| Author | Martijn Tonies |
| Post date | 2003-01-17T09:41:29Z |
Hi Michael,
in inserting a row - perhaps with a 10000 (in a single run). But if you need
to do that, simply drop the index and re-create it afterwards.
With regards,
Martijn Tonies
InterBase Workbench - the developer tool for InterBase & Firebird
Firebird Workbench - the developer tool for Firebird
Upscene Productions
http://www.upscene.com
"This is an object-oriented system.
If we change anything, the users object."
> A field is varchar(200) charset ASCII, and it must be unique. If IWhat do you mean "obviously"? You won't notice any speed difference
> create a unqiue index on that field, will it hurt performance
> obviously, especially for insert?
in inserting a row - perhaps with a 10000 (in a single run). But if you need
to do that, simply drop the index and re-create it afterwards.
With regards,
Martijn Tonies
InterBase Workbench - the developer tool for InterBase & Firebird
Firebird Workbench - the developer tool for Firebird
Upscene Productions
http://www.upscene.com
"This is an object-oriented system.
If we change anything, the users object."