On 8/13/08, Mark Leith <[EMAIL PROTECTED]> wrote: > > > Why not function based indexes, as Baron pointed to as the last option in > his previous reply? > > I've wanted function based indexes since the dawn of time in MySQL - well, > at least since Oracle 8i anyway.. ;) > > http://www.akadia.com/services/ora_function_based_index_2.html > > In MySQL Worklog parlance, they are 'Functional Indexes', or 'Calculated > Indexes', a public worklog for this is here: > > http://forge.mysql.com/worklog/task.php?id=1075 > > This looks like exactly what you guys are talking about, and does not give > the need to store the value in another separate column, with another index > etc. (... more space)..
>From what I understand, "functional indexes" are very close to "materialized views." (so yeah, we're back to views.) -Sheeri
_______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
