Skip to Content
0
Former Member
Dec 08, 2009 at 05:27 AM

Will creating a ZIndex on table CDHDR affect updation speed of the table

314 Views

Hi SDNers,

Does creation of a new Zindex on a standard Table affect the updation of the table?

Example:

I have to create a Zindex on tabl;e CDHDR.

One senior tells me to create a Zindex on the table for fields objectclas, objectid, udate.

another senior tells me that creation of additonal index on the table will affect the updation speed of the table CDHDR.

Request your input on whether the zindex will have any affect on theway the table gets updated?

Regards,

SuryaD.