Re: [SQL] Advice for index design

2013-04-12 Thread Jasen Betts
On 2013-04-10, JORGE MALDONADO wrote: > Our application offers a catalog of artists where a user can select a range > of birthdays and/or sex. For example, a user can get an artists catalog for > those male artists who were born between May 1, 1970 and May 1, 1990 > ordered by birthday and, with

Re: [SQL] Advice for index design

2013-04-11 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 Jorge Maldonado wrote: ... > What is a good index design approach? Maybe, setting simple separate > indexes (one for each field) would work fine if I need to > retrieve data in different combinatios, but I am not sure. Yes, just create separat

Re: [SQL] Advice for index design

2013-04-10 Thread Gavin Flower
On 11/04/13 10:30, JORGE MALDONADO wrote: I have a table of artists with fields like the ones below: * Name * Birthday * Sex (male/female) Our application offers a catalog of artists where a user can select a range of birthdays and/or sex. For example, a user can get an artists catalog for th

[SQL] Advice for index design

2013-04-10 Thread JORGE MALDONADO
I have a table of artists with fields like the ones below: * Name * Birthday * Sex (male/female) Our application offers a catalog of artists where a user can select a range of birthdays and/or sex. For example, a user can get an artists catalog for those male artists who were born between May 1,