Is there additional overhead if indexes are repeated? - 03-12-2007 , 01:31 PM
Version 184.108.40.2061, PocketPC.
I am looking at a client database where there are integer primary keys on
tables and there is a manually created index on the same primary key field
in the same direction. I know this is not needed. It will be helpful if you
could tell me if there would be a performance penalty on size of the
database and / or inserts, updates and synchronizations because of this.
Re: Is there additional overhead if indexes are repeated? - 03-12-2007 , 01:36 PM
In article <45f5aa8a$1@forums-1-dub>, "Priyesh" <priyesh_do_not_reply>
well as processing overhead on inserts, deletes and maybe updates (if
the key field is updated).
Remove the ns_ from if replying by e-mail (but keep posts in the
newsgroups if possible).