systable indexes

Quoting Dave Snyder... > 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. I know you're correct for 4.0, perhaps Nick is using explain and it's telling him that the index is not being used. It is possible that the optimizer decided not to use the index which is feasible since 200 rows is still a fairly small table. Nick, if you are getting your info from explain, you could try doing an update statistics for table systables;then try again. Also, you can verify what indexes are on the table as follows info indexes for systables; Warren J. Saccente Bellcore