Re: ODBC SQLColums is very slow

From: Wolfram Roesler <wr_at_spam.la>
Date: Wed, 21 Jan 2009 11:01:22 +0000 (UTC)
Message-ID: <Xns9B9A7A50B8328wrgrpde_at_news.albasani.net>

Charles Hooper <hooperc2000_at_yahoo.com> wrote in news:a63701d7-e334-4920-ba0a-72c587f70d3c_at_l33g2000pri.googlegroups.com:

> See if the following query returns any rows:
> SELECT
> *
> FROM
> SYS.TAB_STATS$;
It doesn't.

> If no rows are returned by the above, that is an indication that fixed
> object statistics were never collected for the database. If
> necessary, collect fixed object statistics with the following command
> in SQL*PLUS:
> EXEC DBMS_STATS.GATHER_FIXED_OBJECTS_STATS(NULL)
That ran fine, and now above query does return rows, but SQLColumns still is slow.

Unfortunately, switching from ODBC to OLEDB is not an option.

Any further ideas, apart from upgrading the ODBC driver?

Thanks for your help
Wolfram Roesler Received on Wed Jan 21 2009 - 05:01:22 CST