dbTalk Databases Forums  

Is there additional overhead if indexes are repeated?

sybase.public.sqlanywhere.ultralite sybase.public.sqlanywhere.ultralite


Discuss Is there additional overhead if indexes are repeated? in the sybase.public.sqlanywhere.ultralite forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Priyesh
 
Posts: n/a

Default Is there additional overhead if indexes are repeated? - 03-12-2007 , 01:31 PM






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



Reply With Quote
  #2  
Old   
David Kerber
 
Posts: n/a

Default 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>
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).


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.