On 9/16/08, Brian Aker <[EMAIL PROTECTED]> wrote: > > Hi! > > On Sep 17, 2008, at 12:17 AM, Sheeri K. Cabral wrote: > > Speaking of which, I believe that indexes aren't allowed to specify ASC or >> DESC. This means that if I want to ORDER BY foo ASC, bar DESC I can't use >> the index to do the ordering. Will Drizzle fix this? (I'm OK with the >> default being parity -- ASC ASC and DESC DESC, but there should be away to >> achive non-parity, ASC DESC and DESC ASC). >> > > Most of the engines can walk their index forward and reverse so there is > not much reason too. Or am I missing something?
I'm referring to a multi-column index. (a,b) will use an index when you do ORDER BY a ASC, b ASC and ORDER BY a DESC, b DESC but it won't use both the (a,b) parts of the index if you do ORDER BY a ASC, b DESC and ORDER BY a DESC, b ASC because the index is stored in ASC order for each column, and you can't change that (but it can walk backwards, so that's how you have parity). Cheers, > -Brian > > -- > _______________________________________________________ > Brian "Krow" Aker, brian at tangent.org > Seattle, Washington > http://krow.net/ <-- Me > http://tangent.org/ <-- Software > _______________________________________________________ > You can't grep a dead tree. > > > > -- - Sheeri K. Cabral Note: Currently I work for The Pythian Group (http://www.pythian.com/ ), a remote DBA firm, and consulting would constitute a conflict of interest. However, I do recommend our work, and if you're looking for DBA work (I do MySQL work, but they have great Oracle and SQL Server DBAs too) right now, whether you need a few hours a week, or someone fulltime while you continue a job search. I have a webpage with tips on how to find a DBA: http://sheeri.net/how-to-find-a-dba/ I can recommend http://www.toomanyconnections.com as a good site to find MySQL (and Oracle) DBAs. If you're looking for web design, I recommend the small business my husband works for, http://www.digital-loom.com I regret that I have no other information for any other type of position, including developer, programmer and systems administrator.
_______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
