dynamobi/dynamobi — Issue #101: [LDB-222] Auto Index Table APPLIB UDP
Author: dynamobi-build
Created: 2011-12-30 02:13:15+00:00
State: closed
Labels: Applib, LDB

[reporter="ngoodman", created="Sun, 13 Jun 2010 22:36:13 -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