Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-43977

Fully Indexed Collection

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major - P3
    • Resolution: Community Answered
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Backwards Compatibility:
      Fully Compatible

      Description

      We are creation a large collection with 2 fields and both are fully indexed.

       

      For example :

      db.collection.insert ( { x : "sddsqq" })

      db.collection.createIndex ( { x : 1, _id : 1 })

       

      Obviously the index is required for fast random access.  Now the only problem is that the index could end up being larger than the document in terms of storage.  More over 2x the storage is required to store the same 'data' (doc and index entries).

       

      Does Mongo have any plans to make improvement similar to IOT tables in Oracle ?

       

      Thanks

       

      Alex Leong

       

        Attachments

          Activity

            People

            Assignee:
            dmitry.agranat Dmitry Agranat
            Reporter:
            aleong@indeed.com Alex Leong
            Participants:
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: