Shulou(Shulou.com)06/02 Report--

This article shows you how to add indexes in AndoridSQLite database development, the content is concise and easy to understand, it will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

AndoridSQLite database development add index

An index is a means to optimize database lookups by pre-sorting and building index tables on one or more columns of a table. Here is to add an index to the table, as follows:

(1) in the open database, click the gear button in the lower left corner, select the Create Index command, and pop up the Index Creator dialog box, as shown in figure 1.18.

Figure 1.18 Index Creator dialog box

(2) enter the index name in the Index name text box. In the Table drop-down list, select the table to which you want to add an index, such as the Students table. In the option box below, check the column to which you want to add an index, such as Name.

(3) Click the Save button to exit the Index Creator dialog. At this point, an index named nameIndex is added to the table in the database, as shown in figure 1.19.

Figure 1.19 nameIndex Index

The above is how to add indexes in AndoridSQLite database development. Have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.