New index

Posted in 2003

Topics: Versions, Editions & End-of-Life

Demeis, Tony — Wed, 03 Sep 2003 13:04:33 — source: IIUG Forums & Mailing Lists

Hi, If you create a new index on a table already having some indexes is it necessary to run the 'update statistics' on everything again or for just the new index. (using IDS 7.31) Thank you, Tony

↪ replying to Demeis, Tony

Mark Denham — Wed, 03 Sep 2003 14:12:50 — source: IIUG Forums & Mailing Lists

I would only run it for the index. ----- Original Message ----- From: "Demeis, Tony" <Tony.Demeis@moh.gov.on.ca> To: <ids@iiug.org> Sent: Wednesday, September 03, 2003 09:04 Subject: New index [1796] > Hi, > > If you create a new index on a table already having some indexes is it > necessary to run the 'update statistics' on everything again or for just the > new index. > > (using IDS 7.31) > > Thank you, > Tony >

Glossary

IDS (Informix Dynamic Server)
UPDATE STATISTICS