Karan CSkaranblog.hashnode.net·Apr 25, 2023Indexing for high performance, simplified.Indexes are essential components of databases that help improve performance by allowing for efficient data retrieval. They work by creating a data structure that maps the values in a column to their corresponding rows in a table. In this blog post, w...Discuss·10 likesindexing
Siddharththeuniquecoder.hashnode.net·Feb 27, 2023MongoDB _id The most important thing that you should knowHello everyone. Most of us know what databases are why they are used and what are the types. Out of which MongoDB is a popular NoSQL database that is known for its flexibility, scalability, and ease of use. One of the key features of MongoDB is the i...Discuss·4 likesMongoDB
Adham Salamaadhamsalama.hashnode.net·Mar 26, 2023Improve PostgreSQL query performance by utilizing an index-only scanIndexes in PostgreSQL All indexes in PostgreSQL are secondary indexes, meaning that each index is stored separately from the table's main data area (the heap).This means that in an ordinary index scan, each row retrieval requires fetching data from b...Discuss·1 like·33 readsDatabasesDatabases
Karan CSkaranblog.hashnode.net·Apr 25, 2023Indexing for high performance, simplified.Indexes are essential components of databases that help improve performance by allowing for efficient data retrieval. They work by creating a data structure that maps the values in a column to their corresponding rows in a table. In this blog post, w...Discuss·10 likesindexing
Elias Soykatelias-soykat.hashnode.net·Apr 17, 2023MongoDB Indexing, How indexing can improve the speed of your database queriesWhen we want to improve the speed and efficiency of query requests or read operations, there are several approaches we can consider. One crucial approach to consider is database indexing. MongoDB indexing is the process of creating an index on a coll...DiscussMongoDB
Harsh Mangeharshmange.hashnode.net·Apr 16, 2023Database Query Optimization 101: Techniques Every Developer Should KnowDatabase query optimization refers to the process of analyzing a SQL query and finding the most efficient way to execute it. This involves selecting the optimal query execution plan that minimizes the time and resources required to complete the query...DiscussDatabase Query OptimizationDatabases
Harsh Mangeharshmange.hashnode.net·Apr 16, 2023Choosing the Right Indexing Strategy: Clustered vs Non-Clustered IndexesWhen deciding whether to use a clustered or non-clustered index in a database, there are a few factors to consider: Table size and data distribution: If the table is relatively small, a clustered index may not provide significant benefits, and a non...DiscussDatabase IndexingDatabases
Harsh Mangeharshmange.hashnode.net·Apr 16, 2023Basic difference between a Clustered Index and a Non-Clustered IndexIn a database, an index is a data structure that allows for quick access to specific data within a table. Indexes can be categorized into two types: clustered and non-clustered indexes. Clustered Index A clustered index determines the physical order ...DiscussDatabase IndexingDatabases
Harsh Mangeharshmange.hashnode.net·Apr 14, 2023What is Database Indexing by Bitmap Indexing approach?Introduction Bitmap indexing is a type of database indexing that uses bitmap vectors to represent the values of attributes in a table. In this approach, each attribute value is mapped to a bit in a bitmap vector. If the value is present in a record, ...DiscussDatabase IndexingDatabases
Harsh Mangeharshmange.hashnode.net·Apr 14, 2023What is Database Indexing by B-Tree Indexing approach?Introduction B-Tree indexing is a widely used technique for indexing data in relational databases. It provides fast access to data by creating a balanced tree structure of index pages that contain pointers to the data pages in the table. In this appr...DiscussDatabase IndexingDatabases
Harsh Mangeharshmange.hashnode.net·Apr 14, 2023What is Database Indexing by Hash Indexing approach?Hash indexing is a database indexing technique that uses a hash function to compute an index value for each record in a table. The index value is used to locate the record quickly when a search is performed. In this answer, we will explain the hash i...DiscussDatabase IndexingDatabases
Harsh Mangeharshmange.hashnode.net·Apr 14, 2023What is Database Indexing?Introduction Database indexing is a process of creating a data structure that improves the speed of data retrieval operations on a database table. In SQL, we can create indexes on columns of a table to improve the performance of database queries. The...Discuss·26 readsDatabase IndexingDatabases
Anja Strickertechpiranja.hashnode.net·Apr 10, 2023Why Using Index as Key in React.js Map Function Can Cause Problems and How to Fix ThemIntroduction Are you a React Developer looking to ace your next interview? Then you need to know about the problem with using index as a key in a React.js map function. In this blog post, I'll explain why using unique keys is important, how it can im...Discuss·1 likeReact
