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

Fully Indexed Collection

    XMLWordPrintableJSON

Details

    • Icon: Improvement Improvement
    • Resolution: Community Answered
    • Icon: Major - P3 Major - P3
    • None
    • None
    • None
    • None
    • 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

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

            Dates

              Created:
              Updated:
              Resolved: