MySQL Indexing Issues
When setting up Indexes in my SQL dataflow, I notice sometimes that a few columns in the join are not made available for indexing. Why is that? What can I do to fix this? I suspect without the indexing, my dataflow is taking an inordinate amount of time.
Also, in the Domo help on optimizing data flows with indexing, the following recommendation appears:
"You should index the two columns in the ON statement. There are two ways you can accomplish this.
- Adding a new SQL type transform BEFORE the transform where the join is happening.
- Using Easy Indexing you can quickly add an index on one or more columns right in your Table Transform without the use of SQL."
What does #1 mean?
#2 is where my problems are happening where some columns in the join are not available for indexing.
#1 is writing a SQL statement, like
ALTER TABLE t1 ADD INDEX('t1.COLUMN')2
@trafalger I see. Now I finally understand a use case for using the SQL transform in SQL data flows! Thanks.1
@trafalger I do wonder if you add the index in the UI if the data is indexed as it's being loaded into the table, or if if the index is added after CREATE TABLE AS SELECT ...
So i i guess if you wanted to be REALLY fancy you would CREATE TABLE, ALTER TABLE and then load data... but then the table doesn't appear in the UI.Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1
- 7.6K All Categories
- 917 Connectors
- 242 Workbench
- 472 Transform
- 1.8K Magic ETL
- 60 SQL DataFlows
- 445 Datasets
- 31 Visualize
- 197 Beast Mode
- 2K Charting
- 7 Variables
- 14 Cards, Dashboards, Stories
- 1 Automate
- 348 APIs & Domo Developer
- 82 Apps
- 14 Predict
- 3 Jupyter Workspaces
- 11 R & Python Tiles
- 241 Distribute
- 59 Domo Everywhere
- 241 Scheduled Reports
- 14 Manage
- 35 Governance & Security
- 19 Product Ideas
- 1.1K Ideas Exchange
- Community Forums
- 15 Getting Started
- 1 Community Member Introductions
- 49 Community News
- 18 Event Recordings
- 579 日本支部