----------------------------------------------------------------------- WORKLOG TASK -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- TASK...........: Make Indexes first level objects CREATION DATE..: Thu, 30 Jun 2011, 16:11 SUPERVISOR.....: IMPLEMENTOR....: COPIES TO......: CATEGORY.......: Maria-RawIdeaBin TASK ID........: 214 (http://askmonty.org/worklog/?tid=214) VERSION........: Server-5.3 STATUS.........: Un-Assigned PRIORITY.......: 60 WORKED HOURS...: 0 ESTIMATE.......: 0 (hours remain) ORIG. ESTIMATE.: 0 PROGRESS NOTES: DESCRIPTION: An index should be able to exist as an object that is not tied to a physical table. That would allow for indexes that are global to a > partition, and for functional indexes or indexes on virtual columns. The above is extremely hard to do as Indexes are very closely tied to storage engines. What is easier to do is to do functional indexes, where the storage engine will ask MySQL for the index data for a row. ESTIMATED WORK TIME ESTIMATED COMPLETION DATE ----------------------------------------------------------------------- WorkLog (v4.0.0)