maria-developers team mailing list archive

Thread
Date

WL#214 New (by Monty): Make Indexes first level objects

To: maria-developers@xxxxxxxxxxxxxxxxxxx
From: worklog-noreply@xxxxxxxxxxxx
Date: Thu, 30 Jun 2011 16:11:46 +0000 (UTC)

-----------------------------------------------------------------------
                              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)