Could you explain this sequence adopted to increase performance at an update script by using MSSQLServer?
At about 144.000 lines like this:
UPDATE dbo.XX1_StreetZipCodeExt set cNameStreet = 'Rua Padre Eustáquio',cIdNeighborhood = 4013,lIdStreet = 3047 where cZiCode ='35500521' and cIdNeighborhood =4013 and lIdStreet =3047
Open in new window
How to obtain and correctly to interpret this:
Sequence of actions adopted:
Created clustered index by cZiCode, but not UNIQUE, as there are duplicates.
Non-clustered index created by [lIdStreet], [cIdNeighborhood], [cZiCode], as recommended by the Execution Plan.
Thanks in advance.
I'm not clear precisely what you are asking. Do you want to know why the index was suggested? Why/how the index affected the update's execution plan?