The amount of data, and the number and types of indexes you create, determine how much space you need in your IQ database. If you run out of space when loading or inserting into a database, the IQ server rolls back either the entire transaction or rolls back to a savepoint. See “Insufficient disk space”.
In addition to any temporary tables you define explicitly, Sybase IQ uses the temporary store as a temporary result space for sorts, hashes, and bitmaps during loads and deletions. The types of queries issued, the degree of concurrent use, and the size of your data all determine how much space you need for your temporary store.
