Hi, I use the command:

SQLCOLUMNS(h,'CMT.ACHKTVUE','NATIVE','columns')
To check the table structure

Since updating to Oracle 9.2 this command is dramticaly slower.
Anybody know what if anything can be done about this?

I also noticed that

SQLCOLUMNS(h,'ACHKTVUE','NATIVE','columns')
is faster than
SQLCOLUMNS(h,'CMT.ACHKTVUE','NATIVE','columns')

But I can't use it because it returns the table several times if it's in more than one schema.

Any ideas.