Re: Duplicate Index Keys

Posted in 1998

Peter Lancashire — Wed, 03 Jun 1998 17:39:08 +0100 — source: Informix-list mailing list archive (1991-1998)

ttpayne@tuc.com wrote: > > We are trying to identify tables containing highly duplicate > index key values (this is a canned application). Anyone > out there with any scripts/SQL for accomplishing this? > > Please e-mail responses to ttpayne@tuc.com. > > Thanks in advance. Version 7.1+ offers the incredibly useful feature of violations tables. See the manual for how to set these on. Create a unique index on your columns and the violations will be found for you and put in your tables. -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 Mail: Peter.Lancashire.PL1@bayer.co.uk --- My Internet plumbing does not allow me to mail and post news together. Sorry. All opinions are my own and not those of Bayer plc. --- Join Infuse, the UK Informix User Group at http://www.infuse.org.uk/