In article <45f5aa8a$1@forums-1-dub>, "Priyesh" <priyesh_do_not_reply>
says...
Quote:
Version 9.0.2.2451, PocketPC.
Hello,
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.
TIA.
Priyesh |
There will be some additional overhead of space used by the index, as
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).