Indexing system tables?

From: Sean LeBlanc <leblancsx_at_corning.com>
Date: Fri, 28 Aug 1998 17:58:38 GMT
Message-ID: <35e6ef42.85999891@news-server.corning.com>

I'm building an app which gets some info about parent-child relationships between tables, and I'm using all_cons_columns and all_constraints tables for this. Problem is, performance in joining these two tables is terribly slow (15-20 seconds). I see that there are no indexes on these tables. Is it possible to put indexes on these tables with no nasty side effects?

Or is there a better way to do what I am doing?

Cheerio,

---

Sean LeBlanc - leblancsx_at_corning.com, cthulhu_at_mail.vicon.net Java/PowerBuilder/Informix/Sybase/SQL-Server /Oracle/C/C++/Perl/NT/Unix/ Received on Fri Aug 28 1998 - 12:58:38 CDT