Index Advisor Configuration v10
Index Advisor does not require configuration to generate recommendations that are available only for the duration of the current session; to store the results of multiple sessions, you must create the
index_advisor_log table (where Advanced Server will store Index Advisor recommendations). To create the
index_advisor_log table , you must run the
When selecting a storage schema for the Index Advisor table, function and view, keep in mind that all users that invoke Index Advisor (and query the result set) must have
USAGE privileges on the schema. The schema must be in the search path of all users that are interacting with the Index Advisor.
Place the selected schema at the start of your
search_pathparameter. For example, if your search path is currently:
and you want the Index Advisor objects to be created in a schema named
advisor, use the command:
index_advisor.sqlscript to create the database objects. If you are running the psql client, you can use the command:
Specify the pathname to the
index_advisor.sqlscript in place of
Grant privileges on the
index_advisor_logtable to all Index Advisor users; this step is not necessary if the Index Advisor user is a superuser, or the owner of these database objects.
INSERTprivileges on the
index_advisor_logtable to allow a user to invoke Index Advisor.
DELETEprivileges on the
index_advisor_logtable to allow the specified user to delete the table contents.
SELECTprivilege on the
The following example demonstrates the creation of the Index Advisor database objects in a schema named
ia, which will then be accessible to an Index Advisor user with user name
While using Index Advisor, the specified schema
(ia) must be included in