Update statistics

Posted in 1998

Link, David A. — Fri, 13 Nov 1998 14:01:53 -0600 — source: Informix-list mailing list archive (1991-1998)

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_000_01BE0F40.AD4FB200 Content-Type: text/plain Can you run an update statistics high on multiple columns so that you do not have to run through the table multiple times. I am using updstats which I got from ATG which is NOT supported by them and it breaks each of the update statistics high into separate statements, however it lumps all the medium columns together into a single statement. TIA David A. Link Informix Database Administrator West Interactive Corp. (402)573-1000 Ext. 7518 ------_=_NextPart_000_01BE0F40.AD4FB200 Content-Type: application/ms-tnef Content-Transfer-Encoding: base64 eJ8+IhwUAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy b3NvZnQgTWFpbC5Ob3RlADEIAQSAAQASAAAAVXBkYXRlIHN0YXRpc3RpY3MAzgYBCYABACEAAAA2 NkI5RjlBOUNGN0FEMjExQTBBNTAwODBDNzJGOEVCQQBaBwEggAMADgAAAM4HCwANAA4AAwAbAAUA HgEBBYADAA4AAADOBwsADQAOAAEANQAFADYBAQ2ABAACAAAAAgACAAEDkAYAaAYAACkAAAALAAIA AQAAAEAAOQDgDqB1QA++AR4AcAABAAAAEgAAAFVwZGF0ZSBzdGF0aXN0aWNzAAAAAgFxAAEAAAAW AAAAAb4PQHWgqfm5aHrPEdKgpQCAxy+OugAAAgEJEAEAAAD8AQAA+AEAAJ8CAABMWkZ1OPwXOQMA CgByY3BnMTI1FjIA+Atgbg4QMDMz2Q7GZmUPQgH3IAKkA+MJAgBjaArAc2V0MD4gBxMCgwBQAvIR uVRhlmgDcQKAfQqBdWMAUFELA3VsbgIgZQumIIpDA5F5CGAgcnUDoAEDkXVwZGF0ZSBacwGQdAQA F+BjBCBokGlnaCACICBtFWBPF+ALUBeQCOF1bQYxc7hvIHQR4AVAFpJkGgDXFYAFQBHgdheQdBoA FtL7GiADYHUYgRogG1EBoBlBRxjnF+AHgS4gSRcAbb8XMACQDyAXMheyBCB3GGA7EdAd8Wca8QNS ElBUR2cfNQQAB7BPVBegF0Bw4wkRCYAgYnkcUh4wAHCVIeBpBUBiCXBhawQg8yMQH3FvZhxTF08Y VAuAfxtxEhAKsSRWIlAJ8B8QLPEYUG93ZRtABcAiwRmRPnAEIAdAAyAcYgeAZGn3GaAZZxtwZxIg HHAnkSWi/mEkgB5xGUEmdx3gCqIKhHEKgFRJQSvaCvQS8nNQMTcgRBswaSHgQZUd4EwLgGsr1Elu AhCwcm1peC5RAZFhEhD9ElBkL+ADABewJiEFsCvUvlcHkAVAL5AkYCYgYxfgIxtBCFBycC4r1Cg0 gDAyKTU3My0PQBE0QCBFeCuhNzUxXjgtKwvFK+MUkQA24AMA/T9SAwAACwABgAggBgAAAAAAwAAA AAAAAEYAAAAAA4UAAAAAAAADAAKACCAGAAAAAADAAAAAAAAARgAAAAAQhQAAAAAAAAMAA4AIIAYA AAAAAMAAAAAAAABGAAAAAFKFAAC3DQAAHgAEgAggBgAAAAAAwAAAAAAAAEYAAAAAVIUAAAEAAAAE AAAAOC4wAAMABYAIIAYAAAAAAMAAAAAAAABGAAAAAAGFAAAAAAAACwAGgAggBgAAAAAAwAAAAAAA AEYAAAAADoUAAAAAAAADAAeACCAGAAAAAADAAAAAAAAARgAAAAARhQAAAAAAAAMACIAIIAYAAAAA AMAAAAAAAABGAAAAABiFAAAAAAAAHgAJgAggBgAAAAAAwAAAAAAAAEYAAAAANoUAAAEAAAABAAAA AAAAAB4ACoAIIAYAAAAAAMAAAAAAAABGAAAAADeFAAABAAAAAQAAAAAAAAAeAAuACCAGAAAAAADA AAAAAAAARgAAAAA4hQAAAQAAAAEAAAAAAAAAAwAmAAAAAAADADYAAAAAAB4AMUABAAAADwAAAElT RERBTEU1MDA1QkQ1AAADABpAAAAAAB4AMEABAAAADwAAAElTRERBTEU1MDA1QkQ1AAADABlAAAAA AAMAgBD/////AgH5PwEAAABTAAAAAAAAANynQMjAQhAatLkIACsv4YIBAAAABgAAAC9PPVdFU1Qv T1U9T01IL0NOPVJFQ0lQSUVOVFMvQ049T01IMi9DTj1JU0REQUxFNTAwNUJENQAAHgD4PwEAAAAP AAAATGluaywgRGF2aWQgQS4AAB4AOEABAAAADwAAAElTRERBTEU1MDA1QkQ1AAACAfs/AQAAAFMA AAAAAAAA3KdAyMBCEBq0uQgAKy/hggEAAAAGAAAAL089V0VTVC9PVT1PTUgvQ049UkVDSVBJRU5U Uy9DTj1PTUgyL0NOPUlTRERBTEU1MDA1QkQ1AAAeAPo/AQAAAA8AAABMaW5rLCBEYXZpZCBBLgAA HgA5QAEAAAAPAAAASVNEREFMRTUwMDVCRDUAAEAABzDAAN7ePw++AUAACDAAsk+tQA++AR4APQAB AAAAAQAAAAAAAAAeAB0OAQAAABIAAABVcGRhdGUgc3RhdGlzdGljcwAAAAsAKQAAAAAACwAjAAAA AAADAAYQDUyzqAMABxBpAQAAAwAQEAAAAAADABEQAAAAAB4ACBABAAAAZQAAAENBTllPVVJVTkFO VVBEQVRFU1RBVElTVElDU0hJR0hPTk1VTFRJUExFQ09MVU1OU1NPVEhBVFlPVURPTk9USEFWRVRP UlVOVEhST1VHSFRIRVRBQkxFTVVMVElQTEVUSU1FU0kAAAAAJE8= ------_=_NextPart_000_01BE0F40.AD4FB200--