GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Table data covered entirely by indexes

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Table data covered entirely by indexes

    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.

  • #2
    It's not possible in MySQL, no.

    Comment


    • #3
      How about InnoDB with a long primary key? Not smart if you have an additional index though.

      Comment


      • #4
        In InnoDB, the primary key IS the table, so unless there is a secondary index, each value is stored only once, and the effect is that you have "only the index" as you wish.

        Comment

        Working...
        X