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.
Comments
-
#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
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive