Running a Distributed Query

SAP Sybase IQ is more likely to distribute a query that processes a large number of rows than those that require fewer resources.

This task includes two scripts that load and query a significant amount of sample data (10 million rows). The first script creates and loads a Fact table and a Dimension table. The second script runs a query that fetches 3 rows, and generates a query plan in the coordinator and write server directories.

Note: Depending on your system configuration and amount of data, SAP Sybase IQ may choose a query plan that does not distribute to the write server.
  1. Enter the dbisql command to start Interactive SQL.
  2. On the Connect dialog, enter:
    Tab Name Field Value
    Identification Authentication Database
    User ID DBA or dba (case-insensitive)
    Password sql (case-sensitive)
    Action Connect to a running database on this computer
    Server name <localhost>_iqdemo
    Database name iqdemo
    Network TCP/IP protocol options Host <localhost>
    Port 2638
  3. Click Connect.
  4. In Interactive SQL, click File > Open.
  5. Browse to $IQDIR16/demo, and choose dqpdata.sql.
  6. Click Open.
  7. Press F9 to create and load the Dimension table and Fact table.
  8. Click File > Open.
  9. Browse to $IQDIR16/demo, and choose dqpquery.sql.
  10. Click Open.
  11. Press F9 to run the script that runs the query and generates the query plan.
Parent topic: Distribute the Workload
Previous topic: Increasing the iq_main File Size
Next topic: Reviewing the Query Plan