Hands-on task
This task is step 4 of the course “Databases in an evening: SQLite, PostgreSQL, Redis”
SQLite: create an index
The events table in /root/logs.db is growing, and queries by the user_id column are slow. Create an index idx_user on the user_id column.
Reference:sqlite3
What you'll practise:
- sqlite3
- create index
- indexes
- sqlite_master
- full scan