ヒント用テーブルにヒント検索高速化用のインデックスを作成した。

[pghintplan/pg_hint_plan.git] / pg_hint_plan--1.0.sql

diff --git a/pg_hint_plan--1.0.sql b/pg_hint_plan--1.0.sql
index 1c5d9cb..305baa9 100644 (file)
--- a/pg_hint_plan--1.0.sql
+++ b/pg_hint_plan--1.0.sql
@@ -4,8 +4,13 @@
 \echo Use "CREATE EXTENSION pg_hint_plan" to load this file. \quit
 
 CREATE TABLE hint_plan.hints (
+       id                                      serial  NOT NULL,
        norm_query_string       text    NOT NULL,
        application_name        text    NOT NULL,
        hints                           text    NOT NULL,
-       PRIMARY KEY (norm_query_string, application_name)
+       PRIMARY KEY (id)
+);
+CREATE UNIQUE INDEX hints_norm_and_app ON hint_plan.hints (
+       norm_query_string,
+       application_name
 );