Re: ODBC SQLColums is very slow
From: Gerard H. Pille <ghp_at_skynet.be>
Date: Wed, 21 Jan 2009 19:33:03 +0100
Message-ID: <49776a5f$0$2856$ba620e4c_at_news.skynet.be>
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
Date: Wed, 21 Jan 2009 19:33:03 +0100
Message-ID: <49776a5f$0$2856$ba620e4c_at_news.skynet.be>
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. Received on Wed Jan 21 2009 - 12:33:03 CST