On Thu, Mar 17, 2005 at 10:56:10AM -0500, Alexander Ranaldi wrote: > Most of my queries return rows based on UserID, and also only if > Private is FALSE. Would it be in the interest of best performance to > split this table into two tables: "EntriesPrivate", > "EntriesNotPrivate" and remove the "Private" column?
You could do a partial index if you'd like (ie. one only indexing rows where Private=FALSE), but I'm not sure if it's the best solution. /* Steinar */ -- Homepage: http://www.sesse.net/ ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]