MySQL Performance: MySQL => Table data covered entirely by indexes

Members

Help

Home

Home » Performance » MySQL » Table data covered entirely by indexes

Show: Today's Messages :: Show Polls :: Message Navigator

Table data covered entirely by indexes [message #3629]

Tue, 14 October 2008 10:48

neilf
Messages: 4
Registered: October 2008

Junior Member

Hi all.

I have a table that is entirely covered by indexes. That is, every query that I want to perform on the table can be satisfied entirely from indexes, without having to read the table data at all.

This may seem like a bizarre thing to want to do, but does anyone know if it's possible to store the data in MySQL in *just* the indexes, without having to store the table data at all, since the table data is never actually accessed?

If this isn't possible in MySQL, does anyone know of any alternatives? I know that certain column-based stores (for example, C-store) might allow this, by storing my indexes as a set of projections over the data.

Thanks.

Neil.

Report message to a moderator

Previous Topic:	Please suggest me how to improve this search query
Next Topic:	nothing

Goto Forum:

-=] Back to Top [=-

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [

]

Current Time: Sun Jul 5 22:18:20 EDT 2009

Total time taken to generate the page: 0.12193 seconds

.:: Contact :: Home ::.

MySQL is a trademark of Sun Microsystems.
InnoDB is a trademark of Oracle Corp.

Percona Performance Forums are a service of Percona, Inc.
Not affiliated with Sun Microsystems or Oracle Corp.