Article Preview
Buy Now
COLUMN
Databases for Real
REALSQLDatabase (SQLite)
Issue: 4.6 (July/August 2006)
Author Bio: Paul Lefebvre is President and Chief Software Architect of LogicalVue Software.
Article Description: No description available.
Article Length (in bytes): 3,201
Starting Page Number: 36
Article Number: 4613
Related Link(s): None
Excerpt of article text...
Last time we looked at the many commands for manipulating data. Once you have a lot of data loaded, you should consider adding some indexing in order to speed up access to the data. The indexing commands are listed in Table 1.
Adding an Index
An index is essentially a quick way to look up data in a table. Indexing is added to specific columns in a table. The command to add an index is simple:
...End of Excerpt. Please purchase the magazine to read the full article.