Re: Help:Index performance issue
From: Steven Hauser <hause011_at_garnet.tc.umn.edu>
Date: 22 May 2001 18:13:37 -0500
Message-ID: <9eerr1$1lv$1_at_garnet.tc.umn.edu>
Date: 22 May 2001 18:13:37 -0500
Message-ID: <9eerr1$1lv$1_at_garnet.tc.umn.edu>
Depends on the SQL and the index types (bitmap? composit? unique?)
I have seen performance increase when the head of a composit index is the best attribute for most values and good distribution vs. using a lame attribute (few values, skewed distribution).
--Received on Wed May 23 2001 - 01:13:37 CEST
---------------------------------------------------------
Steven Hauser email: hause011_at_tc.umn.edu URL: http://www.sofbot.com/
---------------------------------------------------------