Re: [GENERAL] best way to manage indexes

2009-12-24 Thread Craig Ringer
On 24/12/2009 6:10 AM, Jamie Kahgee wrote: what would be considered "best practice" for my situation? I have a table *member*, with column *name *that I want to put an index on, because it is searched quiet frequently. When I create my sql search string, the name will consist only of alpha-numer

Re: [GENERAL] best way to manage indexes

2009-12-23 Thread Scott Marlowe
On Wed, Dec 23, 2009 at 3:10 PM, Jamie Kahgee wrote: > what would be considered "best practice" for my situation? > I have a table member, with column name that I want to put an index on, > because it is searched quiet frequently. When I create my sql search string, > the name will consist only of