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@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).

-- 


---------------------------------------------------------

Steven Hauser 
email: hause011@tc.umn.edu   URL: http://www.sofbot.com/


---------------------------------------------------------

Received on Tue May 22 2001 - 18:13:37 CDT