Tag:Full-text index

  • Various types of indexes in mongodb

    Time:2021-11-29

    In the previous article, we introduced the simple operations of indexes in mongodb, such as creating, viewing, deleting and other basic operations. However, we only introduced one type of index above. In this article, let’s take a look at other types of indexes. This is the tenth article in mongodb series. Understanding the previous articles […]

  • Advanced MySQL: Information_ Schema introduction

    Time:2021-9-7

    When using the command line to connect to MySQL, we are executingSHOW DATABASESCommand, you will find that there is another database namedINFORMATION_SCHEMAWhat is this representation used for? In mysql,INFORMATION_SCHEMAIt is used to access the metadata of the database (such as database, table name, column data type or access permission). In each MySQL instance,INFORMATION_SCHEMAIt saves the […]

  • Mongodb (V) advanced_ Indexes

    Time:2021-7-9

    Indexes Before we know the index, we first create a table and insert 2 million pieces of data into it. // test.js //Generating random numbers function GetRandomNum(min,max){ let range = max-min; // The interval of random number is obtained let rand = Math.random(); // Get the random value return (min + Math.round(rand *range)); // Minimum […]

  • Index types of MySQL and how to create and maintain them

    Time:2021-6-11

    Index is very important in mysql, which can greatly improve the performance of MySQL. Definition of index It is a kind of data structure that can help MySQL obtain data efficiently, and it can also be said that it is a kind of ordered fast search data structure. There are mainly the following data structures: […]

  • 19 MySQL optimizations commonly used in BTREE projects

    Time:2021-3-22

    1、 Explain To optimize mysql, we should make good use of itEXPLAINView the SQL execution plan. Let’s take a simple example to annotate (1,2,3,4,5) the data we want to focus on Type column, connection type. A good SQL statement should at least reach the range level. Eliminate all levels Key column, the index name used. […]

  • Mongo index learning notes

    Time:2021-3-16

    Index usage scenarios Excellent: speed up the query Inferior: the addition, deletion and modification will cause additional expenses and space occupation Tips: returns more than half of the data in the set, and the efficiency of full table scanning is high Index basis Basic operation View index: db.test.getIndexes () Create index: db.test.ensureIndex ({“username”:1},{“background”:true,”name”:”index_ test_ Name […]

  • Talk about mongodb – mongodb index introduction and sharing

    Time:2020-12-17

    sketch In fact, the indexes in mongodb are similar to relational databases in order to improve the efficiency of query and sorting, and the implementation principle is basically the same. Because the key (field) in the collection can be a normal data type or a subdocument. Mongodb can create indexes on various types of keys. […]

  • Implementation of custom Chinese full text index in neo4j

    Time:2020-12-10

    Generally, the first way to optimize the efficiency of database retrieval is to start with the index, and then consider more complex load balancing, read-write separation and distributed horizontal / vertical sub database / table according to the demand. The index improves the retrieval efficiency through information redundancy, which exchanges space for time and reduces […]

  • SQL Server full text search / full text index

    Time:2020-12-8

    summary Full text engines use information from full-text indexes to compile full-text queries that can quickly search for specific words or phrases in a table. Full text indexes store information about important words and their locations in one or more columns of a database table. Full text index is a special type of mark based […]

  • Laravel uses scout to integrate elasticsearch for full-text search

    Time:2020-11-18

    Version 6.8 onlyLaravel version 5.5 Install required components composer require tamayo/laravel-scout-elastic composer require laravel/scout If there is an error in composer require laravel / Scout Using version ^6.1 for laravel/scout ./composer.json has been updated Loading composer repositories with package information Updating dependencies (including require-dev) Your requirements could not be resolved to an installable set of […]

  • How Oracle creates and uses full text index

    Time:2020-11-12

    There are many ways to search for text in Oracle database without using Oracle Text function. Standard instr function and like operator can be used. SELECT *FROM mytext WHERE INSTR (thetext, ‘Oracle’) > 0; SELECT * FROM mytext WHERE thetext LIKE ‘%Oracle%’; In many cases, instr and like are ideal, especially when the search only […]

  • 5 minutes to quickly understand the various types of MySQL indexes

    Time:2020-10-11

    Articles continue to be updated, wechat search “Wanmao Society“Read for the first time.Reply after follow upe-bookGet 12 Java required technical books for free. What is an index? Index is a data structure used by database storage engine to quickly find the specified data. We can use Xinhua Dictionary as an analogy: if the detailed explanation […]