Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Jerry Gitomer — — source: Informix-list mailing list archive (1991-1998)
Is there a query I can set up that will permit our computer
operators to determine if an index exits on a table?
We have a job that loads four tables and creates a record_id
index on each. Last week one of the programmers had to make
some changes to one of the tables. Somehow he blew the indexes
on three of the four tables (they only have 230,000 rows each).
Needless to say the four table join took forever. (Literally
three orders of magnitude slower than usual).
I know that I can go into DBACCESS and see the indexes for
a table, but I don't plan to on premises when the third shift
operator starts up the joins at 3:00 AM :-) So our operations
manager asked me to come up with an EASY way for an operator
to find out if the indexes exist.
I did Read The Fine Manual, but couldn't find out where Informix
stashes the index names (numbers?) along with the identity of
table being indexed, and the ids of the columns comprising the
index.
Jerry
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.