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

diff --git a/expected/ut-A-9.1.out b/expected/ut-A-9.1.out
index 1878c02..246b93d 100644 (file)
--- a/expected/ut-A-9.1.out
+++ b/expected/ut-A-9.1.out
@@ -181,6 +181,7 @@ SET pg_hint_plan.enable_hint_table TO on;
  hints             | text    | not null
 Indexes:
     "hints_pkey" PRIMARY KEY, btree (id)
+    "hints_norm_and_app" UNIQUE, btree (norm_query_string, application_name)
 
 ----
 ---- No. A-6-2 search condition

diff --git a/expected/ut-A-9.2.out b/expected/ut-A-9.2.out
index f1c03a8..e9322e1 100644 (file)
--- a/expected/ut-A-9.2.out
+++ b/expected/ut-A-9.2.out
@@ -181,6 +181,7 @@ SET pg_hint_plan.enable_hint_table TO on;
  hints             | text    | not null
 Indexes:
     "hints_pkey" PRIMARY KEY, btree (id)
+    "hints_norm_and_app" UNIQUE, btree (norm_query_string, application_name)
 
 ----
 ---- No. A-6-2 search condition

diff --git a/pg_hint_plan--1.0.sql b/pg_hint_plan--1.0.sql
index d07351a..305baa9 100644 (file)
--- a/pg_hint_plan--1.0.sql
+++ b/pg_hint_plan--1.0.sql
@@ -10,3 +10,7 @@ CREATE TABLE hint_plan.hints (
        hints                           text    NOT NULL,
        PRIMARY KEY (id)
 );
+CREATE UNIQUE INDEX hints_norm_and_app ON hint_plan.hints (
+       norm_query_string,
+       application_name
+);