Update Statistics on a GK Index

Posted in 2003

Topics: SQL Development & Query Writing, Triggers, Constraints & Referential Integrity, Jobs, Consulting & Announcements

KEVIN STRUCKHOFF — Fri, 30 May 2003 22:54:34 — source: IIUG Forums & Mailing Lists

What Update statistics plan is optimal for a GK Index on Joined Tables? FWIW, the foreign key on the first table is a concatenation of two columns to join to the primary key of the second table. TIA, Kevin Struckhoff Data Warehouse Consultant Yamaha Motors kevin_struckhoff@yamaha-motor.com

↪ replying to KEVIN STRUCKHOFF

Mark Scranton — Mon, 02 Jun 2003 17:53:17 — source: IIUG Forums & Mailing Lists

Never proven anything around this idea, but I can't imagine that the update stats would be any different for a GK index than an index column for joins...the same rules should apply. I would think that the optimizer would still want to know as much about the index and columns included in the GK as possible. Mr. Mules? HTH - Mark Mark Scranton Principal Consultant/Teacher IBM Denver IBM Software Group - Data Management Office: 303-773-5067 Cell: 303-929-0914 email: mscranto@us.ibm.com "KEVIN STRUC...." <kevinstruckhoff@ To: ids@iiug.org yahoo.com> cc: Sent by: Subject: Update Statistics on a GK Index [1259] forum.subscriber@ iiug.org 05/30/2003 04:54 PM What Update statistics plan is optimal for a GK Index on Joined Tables? FWIW, the foreign key on the first table is a concatenation of two columns to join to the primary key of the second table. TIA, Kevin Struckhoff Data Warehouse Consultant Yamaha Motors kevin_struckhoff@yamaha-motor.com

Glossary

UPDATE STATISTICS