MySQL :: MySQL Forums :: Optimizer & Parser

Announcements	Last Post
• MySQL Cluster 7.4.29 has been released	07/14/2020 02:18AM
• MySQL Cluster 7.5.19 has been released	07/14/2020 02:09AM
• MySQL Cluster 7.6.15 has been released	07/14/2020 01:57AM
• MySQL Connector/J 8.0.21 has been released	07/13/2020 09:07AM
• MySQL Workbench 8.0.21 has been released	07/13/2020 08:20AM

New Topic

Pages:

1 2 3 4 5

...

19 »

Subject

Views

Written By

Posted

Sticky: MySQL 8.0: Hash Join and EXPLAIN ANALYZE (1 Posts)

183

Edwin Desouza

10/01/2019 05:40PM

Sticky: MySQL 8.0: One Giant Leap For SQL (1 Posts)

574

Edwin Desouza

04/25/2018 10:16AM

Sticky: Unofficial MySQL 8.0 Optimizer Guide (1 Posts)

799

Edwin Desouza

02/13/2017 04:16PM

Sticky: MySQL 8.0: Window Functions (1 Posts)

702

Edwin Desouza

02/04/2017 08:57PM

Sticky: MySQL 8.0: CTEs (1 Posts)

1,084

Edwin Desouza

10/18/2016 09:38AM

Sticky: MySQL 8.0: Optimizer & Parser (1 Posts)

1,207

Edwin Desouza

09/13/2016 10:54AM

Sticky: MySQL Performance Tuning (1 Posts)

1,880

Edwin Desouza

07/06/2015 10:37AM

Sticky: MySQL Parser (1 Posts)

2,619

Edwin Desouza

04/03/2014 03:31PM

Sticky: MySQL Optimizer: Features in MySQL 5.7 (1 Posts)

3,982

Edwin Desouza

12/18/2012 11:38AM

Sticky: MySQL EXPLAIN (1 Posts)

4,469

Edwin Desouza

07/10/2012 10:32AM

Sticky: MySQL Optimizer: Blogs (1 Posts)

10,251

Edwin DeSouza

04/28/2007 06:20PM

MySQL 8.0: Modern approaches to replacing accumulation user-defined variable hacks, via Window functions and CTEs

Saverio Miroddi

06/16/2020 10:00AM

MySQL 8.0.20: Index-Level Optimizer Hints

Edwin Desouza

04/28/2020 09:04AM

Explain features

107

Michael Bialik

03/29/2020 01:29PM

Re: Explain features

Peter Brawley

03/29/2020 02:01PM

MySQL 8.0: using CTEs to generate Sequences/Ranges

Edwin Desouza

03/09/2020 01:23PM

MySQL 8.0: A must-know about NOT IN in SQL – more antijoin optimization

Edwin Desouza

02/28/2020 11:12AM

msqldump only one row per minute from a 5 row/minute database

Adrian C

02/22/2020 12:38PM

Re: msqldump only one row per minute from a 5 row/minute database

Peter Brawley

02/22/2020 01:46PM

MySQL 8.0: EXPLAIN ANALYZE

Edwin Desouza

02/14/2020 11:29PM

Explain command type "All" issue

125

Vipin PA

02/14/2020 03:20AM

Re: Explain command type "All" issue

Peter Brawley

02/14/2020 10:28AM

Re: Explain command type "All" issue

Edwin Desouza

02/14/2020 05:52PM

Introduction to MySQL 8.0 CTEs (Part 1+2)

103

Edwin Desouza

02/13/2020 12:02PM

MySQL 8.0: Hash Join

Edwin Desouza

02/09/2020 05:09PM

MySQL 8.0: Simple way to figure out why your recursive CTE is running away

104

Edwin Desouza

01/15/2020 06:06AM

optimizer seems to skip stored function call in where clause?

149

John LeSueur

01/08/2020 11:07AM

Re: optimizer seems to skip stored function call in where clause?

John LeSueur

01/08/2020 11:21AM

Re: optimizer seems to skip stored function call in where clause?

John LeSueur

01/08/2020 11:44AM

Re: optimizer seems to skip stored function call in where clause?

Peter Brawley

01/08/2020 01:11PM

MySQL 8.0: AntiJoin

150

Edwin Desouza

12/18/2019 07:54AM

MySQL 8.0: Hash Join

159

Edwin Desouza

11/13/2019 12:36PM

MySQL 8.0: Understanding Hash Joins

144

Edwin Desouza

10/30/2019 11:06AM

Explain Analyze in MySQL 8

191

Edwin Desouza

10/28/2019 05:00PM

optimizing searches using aggregate data in join

234

Matthew Lenz

10/21/2019 09:05AM

Re: optimizing searches using aggregate data in join

Peter Brawley

10/21/2019 11:37AM

MySQL 8.0: EXPLAIN ANALYZE

164

Edwin Desouza

10/17/2019 07:15AM

MySQL 8.0.18 Maintenance Release is Generally Available

145

Edwin Desouza

10/14/2019 01:06PM

Slow Query

444

Deepak Nirmul

06/21/2019 04:47AM

Re: Slow Query

121

Peter Brawley

06/21/2019 10:17AM

Re: Slow Query

134

Deepak Nirmul

06/24/2019 02:18AM

Re: Slow Query

141

Peter Brawley

06/24/2019 09:56AM

Re: Slow Query

135

Deepak Nirmul

06/24/2019 10:15AM

Re: Slow Query

137

Peter Brawley

06/24/2019 10:45AM

Re: Slow Query

Gopal venkat

09/04/2019 11:47AM

Gopal, please don't hijack threads

102

Peter Brawley

09/04/2019 02:32PM

Re: Slow Query

103

marimuthu B

09/06/2019 05:59AM

Re: Slow Query

117

Peter Brawley

09/06/2019 09:57AM

MySQL 8.0: Supporting all kinds of outer references in derived tables (lateral, or not)

201

Edwin Desouza

07/12/2019 11:13AM

setting an index for speed

281

Michael Peters

07/02/2019 04:56AM

Re: setting an index for speed

135

Peter Brawley

07/02/2019 12:29PM

Query optimization and indexing - Help needed

313

Pandit P

06/13/2019 06:41AM

Re: Query optimization and indexing - Help needed

123

Peter Brawley

06/13/2019 12:55PM

Re: Query optimization and indexing - Help needed

128

Pandit P

06/14/2019 12:01AM

Re: Query optimization and indexing - Help needed

122

Peter Brawley

06/14/2019 07:51AM

Is the query order guaranteed using Btree indexes and no ORDER BY

311

Ted Johnson

05/29/2019 02:12PM

Re: Is the query order guaranteed using Btree indexes and no ORDER BY

134

Peter Brawley

05/29/2019 03:00PM

Re: Is the query order guaranteed using Btree indexes and no ORDER BY

115

Ted Johnson

05/29/2019 04:41PM

CHECK constraints in MySQL

214

Edwin Desouza

05/14/2019 09:37AM

MySQL 8.0: Removal of implicit and explicit sorting for GROUP BY

273

Edwin Desouza

04/10/2019 09:14AM

Comparing two columns on big table

370

Krzysztof Wróblewski

03/21/2019 03:24PM

Re: Comparing two columns on big table

182

Peter Brawley

03/21/2019 04:24PM

help with this query

304

sha fendi

03/16/2019 09:17PM

Re: help with this query

160

Peter Brawley

03/17/2019 11:04AM

MySQL Functional Indexes

248

Edwin Desouza

03/14/2019 09:49AM

MySQL 8.0: Query analytics [CTEs, Window Functions]

256

Edwin Desouza

03/09/2019 11:04PM

MySQL 8.0: Improvements to ROLLUP

262

Edwin Desouza

03/05/2019 11:53AM

MySQL 8.0: Window Functions for JSON

231

Edwin Desouza

02/21/2019 11:08AM

what's the execution order of each part of a sql query

313

aaron chan

02/19/2019 09:00PM

Re: what's the execution order of each part of a sql query

153

Peter Brawley

02/20/2019 10:47AM

MySQL 8.0: New Index Features

321

Edwin Desouza

02/08/2019 11:18AM

MySQL 8.0: support for LATERAL derived tables

285

Edwin Desouza

01/31/2019 11:07AM

MySQL 8.0: Keywords

540

Edwin Desouza

01/10/2019 09:22PM

I Need Help To Write Queries

Mostafa Baghi

12/17/2018 04:40AM

MySQL 8.0: Window Functions with Unusual Boundaries

364

Edwin Desouza

11/08/2018 02:42PM

More SQL in MySQL 8.0

623

Edwin Desouza

11/06/2018 07:28PM

MySQL 8.0: What Is New in Optimizer and Executor?

394

Edwin Desouza

11/01/2018 11:10AM

Optimizer Improvements in MySQL 8.0

359

Edwin Desouza

10/31/2018 09:31PM

Indexes are not working after restoring dump

524

Amit K

09/27/2018 11:25AM

Re: Indexes are not working after restoring dump

294

Amit K

09/27/2018 01:39PM

Re: Indexes are not working after restoring dump

266

Amit K

09/27/2018 01:45PM

Re: Indexes are not working after restoring dump

253

Øystein Grøvlen

09/28/2018 12:21AM

Re: Indexes are not working after restoring dump

302

Peter Brawley

09/27/2018 07:14PM

Re: Indexes are not working after restoring dump

275

Amit K

09/27/2018 08:31PM

Re: Indexes are not working after restoring dump

267

Peter Brawley

09/28/2018 11:08AM

Optimizer produces incorrect resultset

378

J Barchan

09/27/2018 09:35AM

Manipulating queries with non-conforming data via MySQL Query Rewrite Plugin, triggers and stored procedures

388

Edwin Desouza

09/07/2018 10:34AM

Where Clause Optimization

524

Mohammed Yehia El Sayed Abdoh

08/31/2018 06:47AM

Re: Where Clause Optimization

262

Peter Brawley

08/31/2018 01:55PM

Re: Where Clause Optimization

252

Mohammed Yehia El Sayed Abdoh

08/31/2018 03:08PM

Re: Where Clause Optimization

274

Øystein Grøvlen

09/03/2018 02:45AM

long execution time of all requests, drop base

888

Уррик Зарик

06/10/2018 06:10AM

Re: long execution time of all requests, drop base

410

Peter Brawley

06/10/2018 12:24PM

Re: long execution time of all requests, drop base

407

Уррик Зарик

06/10/2018 12:40PM

Re: long execution time of all requests, drop base

440

Peter Brawley

06/10/2018 02:24PM

Re: long execution time of all requests, drop base

452

Urri Zar

06/11/2018 12:09AM

Re: long execution time of all requests, drop base

355

Urri Zar

06/12/2018 10:25AM

Re: long execution time of all requests, drop base

392

Peter Brawley

06/12/2018 10:27AM

Re: long execution time of all requests, drop base

504

Urri Zar

06/12/2018 10:34AM

Re: long execution time of all requests, drop base

505

Peter Brawley

06/12/2018 12:00PM

Create index for Join some table in MySQL

480

Kenny Nguyen

05/20/2018 10:51PM

Re: Create index for Join some table in MySQL

301

Øystein Grøvlen

05/30/2018 12:50AM

Determine time taken by commit statement after insert or update statement

611

Priya Pawar

05/07/2018 02:01AM

Re: Determine time taken by commit statement after insert or update statement

348

Jesús Uzcanga

05/07/2018 08:43AM

Re: Determine time taken by commit statement after insert or update statement

285

Priya Pawar

05/08/2018 12:03AM

MySQL 8.0: One Giant Leap For SQL

367

Edwin Desouza

04/25/2018 10:14AM

how to speed up query on a table with over 20million records?

745

li zheng

03/25/2018 07:27AM

Re: how to speed up query on a table with over 20million records?

377

li zheng

03/25/2018 08:38AM

Re: how to speed up query on a table with over 20million records?

311

Peter Brawley

03/25/2018 01:59PM

Re: how to speed up query on a table with over 20million records?

370

Peter Brawley

03/25/2018 03:04PM

Re: how to speed up query on a table with over 20million records?

331

li zheng

03/25/2018 08:13PM

Re: how to speed up query on a table with over 20million records?

351

Peter Brawley

03/25/2018 10:03PM

Re: how to speed up query on a table with over 20million records?

302

li zheng

03/26/2018 02:41AM

This topic has been moved.: optimizing searches using aggregate data in join

Matthew Lenz

10/21/2019 11:06AM

This topic has been moved.: setting an index for speed

Michael Peters

07/02/2019 12:26PM

This topic has been moved.: Slow Query

Deepak Nirmul

06/21/2019 10:18AM

This topic has been moved.: help with this query

sha fendi

03/17/2019 11:05AM

Pages:

1 2 3 4 5

...

19 »

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.