Subject | Re: Performance when deleting a lot of records |
---|---|
Author | Christian Kaufmann |
Post date | 2005-03-29T09:24:40Z |
> Make your indices as unique as possible. You may add a PK field toI have duplicates in some indexes. Mostly there are 2-10 records with
> of index fields.
the same key. Should I add a field to make the key unique in that
case?
I noticed in the statistics, that I have 3'000'000 nodes in the index,
but the table has only 2'100'000 records. To the nodes represent the
number of possible records in all allocated pages for that index?
Index depth is 3, my page size is 4096. I read somewhere, that
increasing the page size helps with performance. How can I change the
page size of my database?
cu Christian