www.mongodb.com
Open in
urlscan Pro
2600:9000:2490:1a00:7:7859:3840:93a1
Public Scan
URL:
https://www.mongodb.com/docs/manual/core/indexes/create-index/
Submission: On April 04 via api from US — Scanned from DE
Submission: On April 04 via api from US — Scanned from DE
Form analysis
1 forms found in the DOMGET https://mongodb.com/docs/search/
<form role="search" method="GET" action="https://mongodb.com/docs/search/" class="css-1c69emu">
<div class="css-1q5aj3">
<div class="css-36i4c2"><input type="text" placeholder="Search all documentation..." class="css-etrcff" value=""></div>
<div class="css-1hc92ka">
<div class="css-aef77t"><button role="button" type="button" class="css-14k7wrz"><span data-testid="selected-value" class="css-6k4l2y">All Documentation</span>
<div class="css-109dpaz"><svg data-testid="icon" width="16" height="9" viewBox="0 0 16 9" fill="none" xmlns="http://www.w3.org/2000/svg" class="css-1yzkxhp">
<path d="M1.06689 0.799988L8.00023 7.73332L14.9336 0.799988" stroke-linecap="round" stroke-linejoin="round" class="css-1tlq8q9"></path>
</svg></div>
</button>
<div class="css-hn9qqo">
<ul data-testid="options" role="listbox" class="css-ac9zo2">
<li role="option" tabindex="0" class="css-11dtrvq">General Information</li>
<li role="option" tabindex="0" class="css-11dtrvq">All Documentation</li>
<li role="option" tabindex="0" class="css-11dtrvq">Realm Documentation</li>
<li role="option" tabindex="0" class="css-11dtrvq">Developer Articles & Topics</li>
<li role="option" tabindex="0" class="css-11dtrvq">Community Forums</li>
<li role="option" tabindex="0" class="css-11dtrvq">Blog</li>
<li role="option" tabindex="0" class="css-11dtrvq">University</li>
</ul>
</div>
</div><input type="hidden" id="q" name="q" value="">
<div class="css-1myrko"><button type="submit" tabindex="0" class=" css-13l1z36" data-track="true"><img alt="search icon" src="https://webimages.mongodb.com/_com_assets/cms/krc3hljsdwdfd2w5d-web-actions-search.svg?auto=format%252Ccompress"
class="css-r9fohf"></button></div>
</div>
</div>
</form>
Text Content
All Documentation * General Information * All Documentation * Realm Documentation * Developer Articles & Topics * Community Forums * Blog * University * Products Platform AtlasBuild on a developer data platform Platform Services DatabaseDeploy a multi-cloud databaseSearchDeliver engaging search experiencesVector SearchDesign intelligent apps with GenAIStream Processing (Preview)Unify data in motion and data at rest Tools CompassWork with MongoDB data in a GUIIntegrationsIntegrations with third-party servicesRelational MigratorMigrate to MongoDB with confidence Self Managed Enterprise AdvancedRun and manage MongoDB yourselfCommunity EditionDevelop locally with MongoDB Build with MongoDB Atlas Get started for free in minutes Sign Up Test Enterprise Advanced Develop with MongoDB on-premises Download Try Community Edition Explore the latest version of MongoDB Download * Resources Documentation Atlas DocumentationGet started using AtlasServer DocumentationLearn to use MongoDBStart With GuidesGet step-by-step guidance for key tasks Tools and ConnectorsLearn how to connect to MongoDBMongoDB DriversUse drivers and libraries for MongoDB AI Resources HubGet help building the next big thing in AI with MongoDBarrow-right Connect Developer CenterExplore a wide range of developer resourcesCommunityJoin a global community of developersCourses and CertificationLearn for free from MongoDBWebinars and EventsFind a webinar or event near you * Solutions Use cases Artificial IntelligenceEdge ComputingInternet of ThingsMobilePaymentsServerless Development Industries Financial ServicesTelecommunicationsHealthcareRetailPublic SectorManufacturing Solutions LibraryOrganized and tailored solutions to kick-start projectsarrow-right Developer Data Platform Accelerate innovation at scale Learn morearrow-right Startups and AI Innovators For world-changing ideas and AI pioneers Learn morearrow-right Customer Case Studies Hear directly from our users See Storiesarrow-right * Company CareersStart your next adventureBlogRead articles and announcementsNewsroomRead press releases and news stories PartnersLearn about our partner ecosystemLeadershipMeet our executive teamCompanyLearn more about who we are Contact Us Reach out to MongoDB Let’s chatarrow-right Investors Visit our investor portal Learn morearrow-right * Pricing SupportSign In Try Free menu-vertical Docs Menu MongoDB Documentation -------------------------------------------------------------------------------- Back to Develop Applications * MongoDB Manual 7.0 (current) * Introduction * Installation * MongoDB Shell (mongosh) * MongoDB CRUD Operations * Aggregation Operations * Indexes * Create an Index * Specify an Index Name * Drop an Index * Index Types * Index Properties * Index Builds on Populated Collections * Manage Indexes * Measure Index Use * Indexing Strategies * Indexing Reference * Atlas Search * Atlas Vector Search * Time Series * Change Streams * Transactions * Data Modeling * Replication * Sharding * Storage * Administration * Security * Frequently Asked Questions * Reference * Release Notes * Technical Support * Docs Home → Develop Applications → MongoDB Manual CREATE AN INDEX On this page * About this Task * Procedure * Example * Results * Learn More Indexes support efficient execution of queries in MongoDB. If your application is repeatedly running queries on the same fields, you can create an index on those fields to improve performance for those queries. To create an index, use the createIndex() shell method or equivalent method for your driver. This page shows examples for the MongoDB Shell and drivers. ABOUT THIS TASK When you run a create index command in the MongoDB Shell or a driver, MongoDB only creates the index if an index of the same specification does not exist. Although indexes improve query performance, adding an index has negative performance impact for write operations. For collections with a high write-to-read ratio, indexes are expensive because each insert and update must also update any indexes. PROCEDURE -------------------------------------------------------------------------------- ➤ To set the language of the examples on this page, use the Select your language drop-down menu in the right navigation pane. -------------------------------------------------------------------------------- MongoDB Shell C# Java (Async) Java (Sync) Motor Node.js Perl PHP Python Ruby Scala To create an index using the Node.JS driver, use createIndex(). collection.createIndex( { <key and index type specification> }, function(err, result) { console.log(result); callback(result);} Node.js EXAMPLE MongoDB Shell C# Java (Async) Java (Sync) Motor Node.js Perl PHP Python Ruby Scala This example creates a single key descending index on the name field: collection.createIndex( { name : -1 }, function(err, result) { console.log(result); callback(result);} Node.js NOTE INDEX SORT ORDER For a single-field index, the sort order (ascending or descending) of the index key does not matter because MongoDB can traverse the index in either direction. RESULTS To confirm that the index was created, use mongosh to run the db.collection.getIndexes() method: db.collection.getIndexes() Output: [ { v: 2, key: { _id: 1 }, name: '_id_' }, { v: 2, key: { name: -1 }, name: 'name_-1' }] To view information on created indexes using a driver, refer to your driver's documentation. LEARN MORE * To learn how to create indexes in MongoDB Compass, see Manage Indexes in the Compass documentation. * To see how often your indexes are used, see Measure Index Use. * To learn how to specify the name of your index, see Specify an Index Name. * To learn how MongoDB builds indexes, see Index Build Process. ← IndexesSpecify an Index Name → Select your language Node.js On this page * About this Task * Procedure * Example * Results * Learn More Rate this page Ask MongoDB AI English * English * Português * 한국어 * 简体中文 © 2023 MongoDB, Inc. About * Careers * Investor Relations * Legal Notices * Privacy Notices * Security Information * Trust Center Support * Contact Us * Customer Portal * Atlas Status * Customer Support Social * GitHub * Stack Overflow * LinkedIn * YouTube * Twitter * Twitch * Facebook © 2023 MongoDB, Inc. By clicking "Accept All Cookies", you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. You can enable and disable optional cookies as desired.Read our Privacy Policy Manage Cookies Accept All Cookies PRIVACY PREFERENCE CENTER "Cookies" are small files that enable us to store information while you visit one of our websites. When you visit any website, it may store or retrieve information on your browser, mostly in the form of cookies. This information might be about you, your preferences or your device and is mostly used to make the site work as you expect it to. The information does not usually directly identify you, but it can give you a more personalized web experience. Because we respect your right to privacy, you can choose not to allow some types of cookies, but essential cookies are always enabled. Click on the different category headings to find out more and change our default settings. However, blocking some types of cookies may impact your experience of the site and the services we are able to offer. MongoDB Privacy Policy Allow All MANAGE CONSENT PREFERENCES STRICTLY NECESSARY COOKIES Always Active These cookies are necessary for the website to function and cannot be switched off in our systems. They are usually only set in response to actions made by you which amount to a request for services, such as setting your privacy preferences, logging in or filling in forms. You can set your browser to block or alert you about these cookies, but some parts of the site will not then work. These cookies do not store any personally identifiable information. PERFORMANCE COOKIES Performance Cookies These cookies allow us to count visits and traffic sources so we can measure and improve the performance of our site. They help us to know which pages are the most and least popular and see how visitors move around the site. All information these cookies collect is aggregated and therefore anonymous. If you do not allow these cookies we will not know when you have visited our site, and will not be able to monitor its performance. FUNCTIONAL COOKIES Functional Cookies These cookies enable the website to provide enhanced functionality and personalisation. They may be set by us or by third party providers whose services we have added to our pages. If you do not allow these cookies then some or all of these services may not function properly. TARGETING COOKIES Targeting Cookies These cookies may be set through our site by our advertising partners. They may be used by those companies to build a profile of your interests and show you relevant adverts on other sites. They do not store directly personal information, but are based on uniquely identifying your browser and internet device. If you do not allow these cookies, you will experience less targeted advertising. SOCIAL MEDIA COOKIES Social Media Cookies These cookies are set by a range of social media services that we have added to the site to enable you to share our content with your friends and networks. They are capable of tracking your browser across other sites and building up a profile of your interests. This may impact the content and messages you see on other websites you visit. If you do not allow these cookies you may not be able to use or see these sharing tools. Back Button COOKIE LIST Search Icon Filter Icon Clear checkbox label label Apply Cancel Consent Leg.Interest checkbox label label checkbox label label checkbox label label Confirm My Choices