dynamobi/dynamobi — Issue #330: [EXT-8] Auto Index Table APPLIB UDP
Author: dynamobi-build
Created: 2011-12-30 02:31:23+00:00
State: open
Labels: Applib, EXT

[reporter="ksecretan", created="Mon, 6 Jun 2011 15:14:20 -0500 (GMT-05:00)"]
Create an Auto Index Table UDP

APPLIB.AUTO_INDEX_TABLE( tableName , threshold )

that does the following:

- Analyzes the table (estimate stats is fine)

For each column evaluate the following criteria:

-- If the column already has an index, do nothing

-- If the column % unique is < 25% create an index ( see below ). Column unique % is "# of distinct values / # of rows"

- Analyze the table again