[pgsql-jp: 29495] Re: INSERTの速度UP に関して

[sugita ＠ sra.co.jp]

  杉田です。

From: "Tadashi Kanbayashi" <Tadashi.Kanbayashi ＠ toppan.co.jp>
Subject: [pgsql-jp: 29494] Re: INSERTの速度UP に関して
Date: Fri, 28 Mar 2003 17:47:44 +0900

;;; 下記の件で、エラーにならなかったSQLです。
;;; （長いので、FROM句以外はいくらか削除してあります。）
;;; 
;;; お願いします。
;;; 
;;; SELECT
;;; t_cidinf.cid
;;;  FROM
;;;    (
;;;     (
;;;      (
;;;       (
;;;        (
;;;         (
;;;          (t_cidinf INNER JOIN t_contopen
;;;           ON t_cidinf.cid = t_contopen.cid
;;;          ) INNER JOIN t_cpinf
;;;           ON t_contopen.cpcd = t_cpinf.cpcd
;;;         ) INNER JOIN t_cpshare
;;;          ON t_cpinf.cpcd = t_cpshare.cpcd
;;;        ) INNER JOIN t_miminf
;;;         ON t_cpshare.mid = t_miminf.mid
;;;       ) INNER JOIN t_payinf
;;;        ON t_cpinf.payinfcd = t_payinf.payinfcd
;;;      ) INNER JOIN t_tidinf
;;;       ON (t_cidinf.tid = t_tidinf.tid)
;;;        AND (t_miminf.mid = t_tidinf.mid)
;;;     ) INNER JOIN t_paycid
;;;      ON t_miminf.mid = t_paycid.mid
;;;    ) INNER JOIN t_paycidgroup
;;;     ON (t_paycidgroup.cid = t_cidinf.cid)
;;;      AND (t_paycid.paycid = t_paycidgroup.paycid)
;;;    INNER JOIN t_hanroinf
;;;     ON (t_hanroinf.pid = t_contopen.pid)
;;;    INNER JOIN t_shimebi
;;;     ON (t_tidinf.kakincd = t_shimebi.kakincd)
;;;      AND (t_contopen.pid = t_shimebi.pid)
;;;    LEFT JOIN t_bill_detail
;;;     ON t_contopen.pid = t_bill_detail.pid
;;;      AND t_bill_detail.mid = t_miminf.mid
;;;      AND t_bill_detail.tid = t_tidinf.tid
;;;      AND t_bill_detail.cid = t_cidinf.cid
;;;      AND t_bill_detail.billterm = '200303'
;;;   WHERE
;;;    t_contopen.pid = 'ZZZ';

  この形ならば、最初の方の INNER の () 群を取り去っても動きませんか?


Kenji Sugita