Join Sheeri Cabral for an in-depth discussion in this video Indexing CONNECT tables, part of Understanding MariaDB for MySQL Users.
…You can put indexes on your MariaDB tables that connect to…remote files and databases.…Not all remote table types can be indexed.…For example, the XML table type can not be indexed.…Let's take a look at our birthdays CSV table.…We're going to do a SHOW CREATE TABLE birthdays.…Let's explain a select to show that we are currently not using an index.…So let's do an EXPLAIN SELECT * FROM birthdays where FIRST equals Grace.…
And indeed, you can see that the type field is all,…which means we are doing a full table scan.…Now let's add an index.…We will use standard MySQL syntax to add and…drop indexes, even in the CONNECT storage engine, connecting to different files.…So let's do ALTER TABLE birthdays ADD INDEX on first.…Let's repeat our EXPLAIN, and see if the index is used now.…So we hit the up arrow.…Now the type is not ALL, which means it is using an index.…
Specifically, the key field lets us know it is using the index called first.…There are some limitations to indexing CONNECT tables that are reading files.…
- Why use dynamic columns?
- Creating, updating, and querying dynamic columns
- Installing the CONNECT storage engine
- Connecting to remote data
- Connecting to CSV, INI, and XML files
- Using PIVOT tables
- Accessing database metadata
- Working with the Cassandra storage engine
Skill Level Intermediate
Ruby on Rails 4 Essential Trainingwith Kevin Skoglund12h 41m Beginner
1. Dynamic Columns
2. The Power of CONNECT
3. Advanced CONNECT Storage Engine
4. The Cassandra Storage Engine
Next steps1m 46s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.