Re: querying systables

Posted in 1992

Dave Snyder — Thu, 11 Jun 92 7:58:10 EDT — source: Informix-list mailing list archive (1991-1998)

Quoting Nick Rumble... > I have to perform frequent validation against the tabname > column within systables. This column is *not* indexed and > therefore can be quite costly if a database has a large number > of tables (200+). Someone correct me if I'm wrong, but I thought systables had two indexes. One on tabname & owner and the other on just tabid. DAS -- David A. Snyder @ Snide Inc. - Folcroft, PA Current Release is db4glgen-3.6 UUCP: ..!uunet!das13!dave INTERNET: dave.snyder@snide.com