On Wed, Aug 13, 2008 at 9:20 AM, Sheeri K. Cabral <[EMAIL PROTECTED]> wrote: > 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.)
Yeah, and memory fails me on details, but I recall in MS SQL Server calculated columns, functional indexes, and materialized views are pretty tightly bound together. So there's one implementation we could look at to see how some of the challenges may have been overcome. _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
