FAQ #2521, published on 2002-10-15
I am using the commands SQLColumn() and SQLListTable() under Oracle.
How can I speed up these commands?
These two commands will list the tables and table columns of your
Oracle database. We suggest to limit the number of tables and columns to
be browsed.

For the command SQLListTable() you may use the following syntax:
SQLListTable(False,True). Setting the second parameter to True allows you to indicate that you do not want to get a list of temporary tables, system tables, alias tables, etc.

For the command SQLColumn() we suggest to use the following syntax:
SQLColumn(NumConnection,"OWNER.CLIENT"). Prefixing the table owner as the table name allows you to get an almost immediate result.
See also : wd7, oracle, sqlcolumn, sql