MySQL :: MySQL Forums :: Optimizer & Parser

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)

397

Edwin Desouza

10/01/2019 05:40PM

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

770

Edwin Desouza

04/25/2018 10:16AM

Sticky: Unofficial MySQL 8.0 Optimizer Guide (1 Posts)

1,034

Edwin Desouza

02/13/2017 04:16PM

Sticky: MySQL 8.0: Window Functions (1 Posts)

911

Edwin Desouza

02/04/2017 08:57PM

Sticky: MySQL 8.0: CTEs (1 Posts)

1,319

Edwin Desouza

10/18/2016 09:38AM

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

1,445

Edwin Desouza

09/13/2016 10:54AM

Sticky: MySQL Performance Tuning (1 Posts)

2,084

Edwin Desouza

07/06/2015 10:37AM

Sticky: MySQL Parser (1 Posts)

2,970

Edwin Desouza

04/03/2014 03:31PM

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

4,224

Edwin Desouza

12/18/2012 11:38AM

Sticky: MySQL EXPLAIN (1 Posts)

4,709

Edwin Desouza

07/10/2012 10:32AM

Sticky: MySQL Optimizer: Blogs (1 Posts)

10,510

Edwin DeSouza

04/28/2007 06:20PM

Query optimization on LIKE

Sing Lau

10/04/2021 12:08PM

Re: Query optimization on LIKE

Peter Brawley

10/04/2021 01:08PM

Multi-valued index is not in possible keys when there is a subquery

Jinlin Yang

07/22/2021 07:18PM

Re: Multi-valued index is not in possible keys when there is a subquery

Peter Brawley

10/04/2021 12:55PM

Run ANALYZE TABLE — Do Not Rely on InnoDB's Automatic Recalculation of Statistics

Edwin Desouza

09/08/2021 09:52AM

MySQL: EXPLAINing the Different EXPLAINS

109

Edwin Desouza

08/19/2021 02:57PM

Disable caching in MYSQL for True performance testings?

176

Sing Lau

07/11/2021 02:47PM

Re: Disable caching in MYSQL for True performance testings?

Peter Brawley

07/11/2021 05:21PM

Documentation regarding operator precedence incorrect for LIKE, REGEXP, IN?

112

Justin Ng

06/12/2021 01:29PM

How to optimizate COUNT query with multiple LEFT JOIN

115

Ivan Stoqnov

06/01/2021 01:19AM

Re: How to optimizate COUNT query with multiple LEFT JOIN

Ivan Stoqnov

06/01/2021 01:31AM

Re: How to optimizate COUNT query with multiple LEFT JOIN

Peter Brawley

06/01/2021 12:19PM

Need help with tracing how identifiers are parsed; dot-reserved vs dot-space-reserved

119

Justin Ng

05/25/2021 05:28AM

Re: Need help with tracing how identifiers are parsed; dot-reserved vs dot-space-reserved

Justin Ng

05/25/2021 06:21AM

MySQL Invisible Column

193

Edwin Desouza

01/22/2021 01:48PM

mySQL 8 - view query not using outer predicate

241

Jack Crawford

01/11/2021 10:49AM

Re: mySQL 8 - view query not using outer predicate

107

Peter Brawley

01/11/2021 12:07PM

Re: mySQL 8 - view query not using outer predicate

124

Jack Crawford

01/11/2021 12:18PM

Re: mySQL 8 - view query not using outer predicate

108

Peter Brawley

01/11/2021 01:38PM

Re: mySQL 8 - view query not using outer predicate

102

Jack Crawford

01/11/2021 02:06PM

Re: mySQL 8 - view query not using outer predicate

103

Peter Brawley

01/11/2021 03:02PM

Re: mySQL 8 - view query not using outer predicate

Jack Crawford

01/11/2021 04:04PM

Re: mySQL 8 - view query not using outer predicate

104

Peter Brawley

01/11/2021 10:34PM

MySQL Comparing INTs and CHARs

226

Edwin Desouza

08/24/2020 02:56PM

MySQL 8.0 Indexes, Histograms, and Other Ways to Speed Up Your Queries

229

Edwin Desouza

08/04/2020 07:57PM

MySQL: Using SKIP LOCK For Queue Processing

312

Edwin Desouza

08/03/2020 10:00AM

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

253

Saverio Miroddi

06/16/2020 10:00AM

MySQL 8.0.20: Index-Level Optimizer Hints

294

Edwin Desouza

04/28/2020 09:04AM

Explain features

364

Michael Bialik

03/29/2020 01:29PM

Re: Explain features

178

Peter Brawley

03/29/2020 02:01PM

MySQL 8.0: using CTEs to generate Sequences/Ranges

290

Edwin Desouza

03/09/2020 01:23PM

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

282

Edwin Desouza

02/28/2020 11:12AM

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

314

Adrian C

02/22/2020 12:38PM

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

179

Peter Brawley

02/22/2020 01:46PM

MySQL 8.0: EXPLAIN ANALYZE

313

Edwin Desouza

02/14/2020 11:29PM

Explain command type "All" issue

333

Vipin PA

02/14/2020 03:20AM

Re: Explain command type "All" issue

167

Peter Brawley

02/14/2020 10:28AM

Re: Explain command type "All" issue

191

Edwin Desouza

02/14/2020 05:52PM

Introduction to MySQL 8.0 CTEs (Part 1+2)

335

Edwin Desouza

02/13/2020 12:02PM

MySQL 8.0: Hash Join

258

Edwin Desouza

02/09/2020 05:09PM

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

286

Edwin Desouza

01/15/2020 06:06AM

optimizer seems to skip stored function call in where clause?

355

John LeSueur

01/08/2020 11:07AM

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

213

John LeSueur

01/08/2020 11:21AM

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

149

John LeSueur

01/08/2020 11:44AM

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

215

Peter Brawley

01/08/2020 01:11PM

MySQL 8.0: AntiJoin

331

Edwin Desouza

12/18/2019 07:54AM

MySQL 8.0: Hash Join

361

Edwin Desouza

11/13/2019 12:36PM

MySQL 8.0: Understanding Hash Joins

340

Edwin Desouza

10/30/2019 11:06AM

Explain Analyze in MySQL 8

371

Edwin Desouza

10/28/2019 05:00PM

optimizing searches using aggregate data in join

484

Matthew Lenz

10/21/2019 09:05AM

Re: optimizing searches using aggregate data in join

197

Peter Brawley

10/21/2019 11:37AM

MySQL 8.0: EXPLAIN ANALYZE

389

Edwin Desouza

10/17/2019 07:15AM

MySQL 8.0.18 Maintenance Release is Generally Available

380

Edwin Desouza

10/14/2019 01:06PM

Slow Query

733

Deepak Nirmul

06/21/2019 04:47AM

Re: Slow Query

289

Peter Brawley

06/21/2019 10:17AM

Re: Slow Query

283

Deepak Nirmul

06/24/2019 02:18AM

Re: Slow Query

260

Peter Brawley

06/24/2019 09:56AM

Re: Slow Query

267

Deepak Nirmul

06/24/2019 10:15AM

Re: Slow Query

288

Peter Brawley

06/24/2019 10:45AM

Re: Slow Query

243

Gopal venkat

09/04/2019 11:47AM

Gopal, please don't hijack threads

231

Peter Brawley

09/04/2019 02:32PM

Re: Slow Query

224

marimuthu B

09/06/2019 05:59AM

Re: Slow Query

260

Peter Brawley

09/06/2019 09:57AM

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

380

Edwin Desouza

07/12/2019 11:13AM

setting an index for speed

490

Michael Peters

07/02/2019 04:56AM

Re: setting an index for speed

257

Peter Brawley

07/02/2019 12:29PM

Query optimization and indexing - Help needed

597

Pandit P

06/13/2019 06:41AM

Re: Query optimization and indexing - Help needed

248

Peter Brawley

06/13/2019 12:55PM

Re: Query optimization and indexing - Help needed

244

Pandit P

06/14/2019 12:01AM

Re: Query optimization and indexing - Help needed

249

Peter Brawley

06/14/2019 07:51AM

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

588

Ted Johnson

05/29/2019 02:12PM

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

256

Peter Brawley

05/29/2019 03:00PM

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

244

Ted Johnson

05/29/2019 04:41PM

CHECK constraints in MySQL

510

Edwin Desouza

05/14/2019 09:37AM

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

461

Edwin Desouza

04/10/2019 09:14AM

Comparing two columns on big table

1,063

Krzysztof Wróblewski

03/21/2019 03:24PM

Re: Comparing two columns on big table

363

Peter Brawley

03/21/2019 04:24PM

help with this query

508

sha fendi

03/16/2019 09:17PM

Re: help with this query

294

Peter Brawley

03/17/2019 11:04AM

MySQL Functional Indexes

422

Edwin Desouza

03/14/2019 09:49AM

MySQL 8.0: Query analytics [CTEs, Window Functions]

443

Edwin Desouza

03/09/2019 11:04PM

MySQL 8.0: Improvements to ROLLUP

440

Edwin Desouza

03/05/2019 11:53AM

MySQL 8.0: Window Functions for JSON

418

Edwin Desouza

02/21/2019 11:08AM

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

522

aaron chan

02/19/2019 09:00PM

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

269

Peter Brawley

02/20/2019 10:47AM

MySQL 8.0: New Index Features

521

Edwin Desouza

02/08/2019 11:18AM

MySQL 8.0: support for LATERAL derived tables

488

Edwin Desouza

01/31/2019 11:07AM

MySQL 8.0: Keywords

854

Edwin Desouza

01/10/2019 09:22PM

I Need Help To Write Queries

262

Mostafa Baghi

12/17/2018 04:40AM

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.