Database Object Management

Sybase IQ lets you create, alter and delete databases and database objects such as tables, views, indexes, procedures, and login policies.

• Sybase IQ Database Design
  The right database design enhances data usability and the speed of data retrieval.
• Tools for Working with Database Objects
  Sybase IQ includes three utilities for working with database objects: Sybase Central, Sybase Control Center, and Interactive SQL. In addition, PowerDesigner can be used for designing and creating whole data warehouses.
• Setting Up a Sybase IQ Database
  Creating an IQ database is part of a larger setup process that begins with installation and ends when your database is available to users.
• Range Partitions
  Partitioning is a scheme of dividing large objects into subobjects.
• Database Definition
  To define your database, you can use SQL statements or you can use a database design tool.
• Data Storage
  A DBA can determine which tables, indexes, and join indexes reside on a given dbspace, relocate objects to other dbspaces, and drop any dbspace after emptying it of data.
• Dbspace Management Example
  This section illustrates the dbspace management process from creating a new database and adding objects and data to the database, through relocating objects and dropping the empty dbspace. This example includes sample SQL code and the output of the related system stored procedures.
• Table Management
  When you create a database, the only tables in it are the system tables, which hold the database schema.
• View Management
  Views are computed tables.
• Index Management
  Sybase IQ indexes dramatically improve the performance of database searches over searches in traditional relational databases.