MongoDB indexing for different datatypes of same key

Question

Suppose I have a three documents where "B" field is present. All the three have 3 different datatypes. How the Index BTREE is stored? And making "B" as an index key is efficient?

Example.

{_id:"1",a:1,b:"abc" }        //B is string here 
{_id:"1",a:1,b:[1,2,3] }      //B is array of numbers
{_id:"1",a:1,b:{x:1,y:"a"} }  //B is another nested document

Perfect. Thank you so much. So SORT mechanism is there even in BTREE node placements — manikawnth
– manikawnth, Commented Sep 1, 2014 at 16:44

wdberkeley · Accepted Answer · 2014-09-01 01:20:35Z

5

It doesn't work any different than if they are all the same type. It's not any more or less efficient than if they are all the same type. Just be aware of how sorting will work- different types will be compared by the BSON type ordering.

answered Sep 1, 2014 at 1:20

wdberkeley

11.7k1 gold badge30 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MongoDB indexing for different datatypes of same key

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related