Re: ODBC SQLColums is very slow

From: Shakespeare <>
Date: Wed, 21 Jan 2009 19:52:29 +0100
Message-ID: <49776eeb$0$182$>

Gerard H. Pille schreef:
> Shakespeare schreef:
>> I ran the second query with the join (with actual tablenames) with sql 
>> plus on one of our production databases; takes more than a second as 
>> well. If I persist running the same query on the same table, it tunes 
>> down to 0,6 seconds. So it seems it's a slow query anyway.... so 
>> replacing ODBC with anything else won't help much. It's the second 
>> part of the union that is slow. The first part runs within 0.1 second.
>> Joining all_tab_columns with all_synonyms seems a bad idea....
>> Shakespeare

> There is another solution that I found on the web.
> In the schema of the user running the query, create tables all_synonyms
> and all_tab_columns, ...
> Fill them with data and add the necessary indexes.
> Barbatruc.

Materialized views would be the option then.... shakespeare Received on Wed Jan 21 2009 - 12:52:29 CST

Original text of this message