Subject | PK and indexes |
---|---|
Author | Adomas Urbanavicius |
Post date | 2005-03-29T10:09:57Z |
Hi,
I noticed interesting thing : There are unique pair of fields in table.
If I make them as primary key, application commit action takes forever.
But leaving only simple unique index on that pair makes no significant
influence on perfomance.
PS. records ~ 3mil.
Adomas
I noticed interesting thing : There are unique pair of fields in table.
If I make them as primary key, application commit action takes forever.
But leaving only simple unique index on that pair makes no significant
influence on perfomance.
PS. records ~ 3mil.
Adomas