Re: Query to find indexes for a specific table

The sysindexes table holds index information. If you are interested in indexes for a specifc table join with systables on the tabid field. -Bill } } 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 } -- Bill Ennis Voice: 312-474-7516 SSA Fax: 312-474-7460 500 W. Madison email: ennis@ssax.com ennis@accesschicago.net