Chat now with support
Chat with Support

Toad Data Point 5.5 - User Guide

Create/Drop Index for a TIC Object

You can create an index on a snapshot or a dataset when you publish these objects to Toad Intelligence Central. A single index is created on each of the columns you select. Any indexing on the remote objects is not inherited by the dataset.

Note: When you select multiple columns to index, a single index is created on each column. A composite index is not created.

To create indexes when publishing

  1. When publishing a data object, in the Publish to Intelligence Central dialog, click the Indexing Options link.
  2. Select the columns on which to create indexes. A key icon appears to the left of a column selected for indexing.

To create/drop indexes for an object in TIC

  1. In the Object Explorer, select the object in which you want to create or drop indexes.
  2. To create an index, click .
  3. To drop an index, click .

 

Note: There is a maximum index size (key length) of 1000 bytes.

 

Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating