Placement of Tables

Sybase IQ creates tables in your current database.

If you are connected to an IQ database, tables are placed as follows:

Table placement
Type of table	Permitted placement	Default placement
Permanent	IQ store, catalog store	IQ store
Global temporary	IQ temporary store, catalog store	IQ temporary store
Local temporary	IQ temporary store or catalog store; only visible to user who creates it	IQ temporary store

Join Virtual Tables

A Join Virtual Table is a denormalized table that looks like a regular table; it has a name, columns, rows, and indexes.

Sybase IQ creates Join Virtual Tables as a result of a CREATE JOIN INDEX for internal processing purposes and deletes them when you do a DROP JOIN INDEX. You cannot create, modify, or delete Join Virtual Tables, but you may see error messages related to them if you try to use or modify them. Sybase suggests that you ignore all Join Virtual Tables.

Servers running in a multiplex cannot create or drop join indexes. For more information, see Using Sybase IQ Multiplex.