Databases
StackOverflow2013
Postsdbo
POMongoDB $query operator ignores index?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POMongoDB $query operator ignores index?
    primarykey
    data
    text
    <p>I created a test MongoDB collection "sampleCollection" with documents which looks like:</p> <pre><code> "_id" : ObjectId("510929e041cb2179b41ace1c"), "stringField" : "Random string0", "longField" : NumberLong(886) </code></pre> <p>and has index on field "stringField". When I execute </p> <pre><code>db.sampleCollection.find({"stringField":"Random string0"}).explain() </code></pre> <p>everything is ok:</p> <pre><code> "cursor" : "BtreeCursor stringField_1", "isMultiKey" : false, "n" : 2, "nscannedObjects" : 2, "nscanned" : 2, "nscannedObjectsAllPlans" : 2, "nscannedAllPlans" : 2, "scanAndOrder" : false, "indexOnly" : false, "nYields" : 0, "nChunkSkips" : 0, "millis" : 0, "indexBounds" : { "stringField" : [ [ "Random string0", "Random string0" ] ] } </code></pre> <p>but </p> <pre><code>db.sampleCollection.find({$query:{"stringField":"Random string0"}}).explain() </code></pre> <p>gets me</p> <pre><code>"cursor" : "BasicCursor", "isMultiKey" : false, "n" : 0, "nscannedObjects" : 4, "nscanned" : 4, "nscannedObjectsAllPlans" : 4, "nscannedAllPlans" : 4, "scanAndOrder" : false, "indexOnly" : false, "nYields" : 0, "nChunkSkips" : 0, "millis" : 0, "indexBounds" : { } </code></pre> <p>This is not looks like a problem, but I'm using <strong>org.springframework.data.mongodb</strong> framework in production and usage of query constructions is an only way to write repositories. And thus I have a db which completely ignores indexed data.</p> <p>Is it correct? Or I misunderstood something?</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USFakeUser
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POMongoDB $query operator ignores index?
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POMongoDB $query operator ignores index?
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POMongoDB $query operator ignores index?
      1. This table or related slice is empty.
      1. VTUpMod
    1. COI saw this exact problem with `$sort` on another question there was no real solution to it :( yea not much help but lets you know this probably isn't just something noobish
      singulars
      1. POMongoDB $query operator ignores index?
      1. USSammaye
    2. COI tried to search the [MongoDB jira](https://jira.mongodb.org/secure/IssueNavigator.jspa) for problems with `$query` but I can't figure out how to search for that w/o getting the thousands of results for `query` as well. Anyone know how?
      singulars
      1. POMongoDB $query operator ignores index?
      1. USJohnnyHK
    3. COEven more funny when you use hint for an index it not even returns results.
      singulars
      1. POMongoDB $query operator ignores index?
      1. USattish
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload