Tips on Introspecting Based on a CREATE TABLE Statement
Under some circumstances, you can significantly reduce introspection time by collecting metadata based on the issued CREATE TABLE DDL statement rather than by introspecting it from the database after the table has been created. A configuration parameter is available for doing this.
To introspect a data source based on CREATE TABLE statement
1. Select Administration > Configuration from the main Studio menu.
2. Navigate to Server > Configuration > Debugging > DDL > Introspect newly created table using data source introspection.
3. Set the parameter value to True.
4. If you use the DDL statement to introspect, you can only examine table columns, primary keys, and indexes. Also, the results may be different from data source introspection.