Disabling indexing

By default, the Actuate SQL compiler creates indexes for rows that are materialized in memory during query execution, for example the rows returned when the right side of a nested loop join is executed. You can disable indexing using the pragma applyIndexing.

For example, to disable indexing for a query, set the pragma applyIndexing to False:

PRAGMA "applyIndexing" := 'false'

SELECT

  NATION.N_NAME,  SUM(LINEITEM.L_EXTENDEDPRICE * (1 - LINEITEM.L_DISCOUNT)) AS Revenue

FROM

  "/SQL_Server/CUSTOMER.SMA" CUSTOMER,

  "/Oracle/ORDERS.SMA" ORDERS,

  "/SQL_Server/LINEITEM.SMA" LINEITEM,

  "/SQL_Server/SUPPLY.SMA" SUPPLY,

  "/Oracle/NATION.SMA" NATION,

  "/Oracle/REGION.SMA" REGION

WHERE

  …

If you create a query using an information object for which indexing is disabled, indexing is disabled for the query as well.

Copyright Actuate Corporation 2012