MongoDB Lab5: Indexes

Indexes support the efficient resolution of queries. Without indexes, MongoDB must scan every document of a collection to select those documents that match the query statement. This scan is highly inefficient and require MongoDB to process a large volume of data.

Indexes are special data structures, that store a small portion of the data set in an easy-to-traverse form. The index stores the value of a specific field or set of fields, ordered by the value of the field as specified in the index.

The createIndex() Method

To create an index, you need to use createIndex() method of MongoDB.

Syntax

The basic syntax of createIndex() method is as follows().

>db.COLLECTION_NAME.createIndex({name:1})


Here key is the name of the field on which you want to create index and 1 is for ascending order. To create index in descending order you need to use -1.

Example


>db.mycol.cretaeIndex({"title":1})
{

    "createdCOllectionAUtomatically" : false,
    "numIndexesBefore" : 1,
    "numIndexesAfter" : 2,
    "ok" : 1

}

In createIndex() method you can pass multiple fields, to create index on multiple fields.

>db.mycol.createIndex({"title":1,"description':-1})

use >db.col.getIndexes() to list out all Indexes in the collection


The dropIndex() method

You can drop a particular index using the dropIndex() method of MongoDB.

Syntax

The basic syntax of DropIndex() method is as follows().


>db.COLLECTION_NAME.dropIndex({name:1})


Example


>db.mycol.dropIndex({"title":1})


Comments

Post a Comment

Popular posts from this blog

AIDS Meanstack Sample questions

Image
1.  1. A AIM:  Include the Metadata element in Homepage.html for providing description as "IEKart's is an online shopping website that sells goods in retail. This company deals with various categories like Electronics, Clothing, Accessories etc. Program: <html> <head>   <meta charset="UTF-8">   <meta name="description" content="IEKart's is an online shopping website that sells goods in retail. This company deals with various categories like Electronics, Clothing, Accessories etc. ">   <meta name="keywords" content="Electronics, Clothing, Accessories" >   <meta name="author" content="John Doe">   <meta name="viewport" content="width=device-width, initial-scale=1.0"> </head> <body> IEKart's is an online shopping website that sells goods in retail. This company deals with various categories like Electronics, Clothing, Accessorie...
Read more
      1.         A) Link "Login", "SignUp" and "Track order" to "Login.html", "SignUp.html" and "Track.html" page respectively.    B) Show functionality of the global attributes such as contenteditable, spellcheck, id      2.          Create following  Tables with Table Elements : Colspan/Rowspan Attributes,  Try different border, cellspacing, cellpadding attributes       3.         A) Create Form Elements, Color and Date Pickers, Select and Datalist Elements B) Add media content in a frame using audio, video, iframe elements to the Home page of IEKart's Shopping application.        4. Write a JavaScript program to find the area of a circle using radius   and PI (const) using HTML   5. ...
Read more

Express.js Registration form data 2 Server

Open Command prompt and Go to your Project folder and run these commands    npm install --save pug npm install --save body-parser npm install --save multer create index.js file in your project folder from Visual studio code with following code var express = require ( 'express' ); var bodyParser = require ( 'body-parser' ); var multer = require ( 'multer' ); var upload = multer (); var app = express (); app . get ( '/' , function ( req , res ){     res . render ( 'form' ); }); app . set ( 'view engine' , 'pug' ); app . set ( 'views' , './views' ); // for parsing application/json app . use ( bodyParser . json ()); // for parsing application/xwww- app . use ( bodyParser . urlencoded ({ extended : true })); //form-urlencoded // for parsing multipart/form-data app . use ( upload . array ()); app . use ( express . static ( 'public' )); app . post ( '/' , function ( req , res ){     console . l...
Read more