Re: Avoiding multi-col indexes & increasing speed inspite of fully-enforced constraints on a fully-normalized db

Hi! Please post the actual SHOW CREATE TABLE statements for the tables in question. Thanks! Jay On Mon, 2006-09-18 at 12:03 +0500, Asif Lodhi wrote: > Hi, > > I have a multi-column index (TrnsxType, TrnsxDate, TrnsxID, DepartID). > This index along with > a multi-column index of some child ta

Avoiding multi-col indexes & increasing speed inspite of fully-enforced constraints on a fully-normalized db

Hi, I have a multi-column index (TrnsxType, TrnsxDate, TrnsxID, DepartID). This index along with a multi-column index of some child tables results in 8-column indexes (TrnsxType, TrnsxDate, TrnsxID, DepartID, OrderType, OrderDate, OrderNo, DepartmentID), etc. I cannot eliminate Department ID be