Running a Distributed Query

The query engine 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, the Sybase IQ query engine may choose a query plan that does not distribute to the write server.
  1. Choose Tools > Sybase IQ 15 > Open Interactive SQL.
  2. On the Connect dialog, click Advanced, 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. In Interactive SQL, click File > Open.
  4. Browse to %ALLUSERSPROFILE%\SybaseIQ\demo, and choose dqpdata.sql
  5. Press F9 to create and load the Dimension table and Fact table.
  6. Click File > Open.
  7. Browse to %ALLUSERSPROFILE%\SybaseIQ\demo, and choose dqpquery.sql
  8. 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