Re: an SQL question

Posted in 1994

Billy Wheeler — 26 Mar 94 19:28:00 GMT — source: Informix-list mailing list archive (1991-1998)

Hi! -> The npused column of the systables catalog has this information. -> Look it up using the name of the table, as in: Remembering to "update statistics" first, of course :-) -> : 3. the length of all the indexes for that table? I think an easier cheat is available from 5.0 on. DBSCHEMA will do it for you in a comment on the first line of the output. Regards Billy PS loved your .sig ---- Digitec Online - 20 Nodes....* Johannesburg, South Africa +27-11-476-2008 .............................* Best BBS * RsaNET User Choice Awards 1993 first.last@digitec.co.za.....* Best Sysop * RsaNET User Choice Awards 1993