Re: querying systables

In article <9035@emory.mathcs.emory.edu> nick@tetra.co.uk (Nick Rumble) writes: > > 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+). Since 4.0 (oldest manual in reach) systables has a composite index on tabname, owner; which would be usable in a search on tabname. Others have posted other remarks (the suggestion to update statistics sounds good) but... In your shoes, I would consider that 18*200 ~= 4K bytes is a pretty reasonable overhead, and I'd think about reading the whole tabname column one time and making an in-memory lookup table. That should make a "frequent" validation go pretty good...