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)

Edwin Desouza

10/01/2019 05:40PM

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

460

Edwin Desouza

04/25/2018 10:16AM

Sticky: Unofficial MySQL 8.0 Optimizer Guide (1 Posts)

695

Edwin Desouza

02/13/2017 04:16PM

Sticky: MySQL 8.0: Window Functions (1 Posts)

607

Edwin Desouza

02/04/2017 08:57PM

Sticky: MySQL 8.0: CTEs (1 Posts)

959

Edwin Desouza

10/18/2016 09:38AM

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

1,076

Edwin Desouza

09/13/2016 10:54AM

Sticky: MySQL Performance Tuning (1 Posts)

1,764

Edwin Desouza

07/06/2015 10:37AM

Sticky: MySQL Parser (1 Posts)

2,470

Edwin Desouza

04/03/2014 03:31PM

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

3,863

Edwin Desouza

12/18/2012 11:38AM

Sticky: MySQL EXPLAIN (1 Posts)

4,374

Edwin Desouza

07/10/2012 10:32AM

Sticky: MySQL Optimizer: Blogs (1 Posts)

10,094

Edwin DeSouza

04/28/2007 06:20PM

MySQL 8.0: Hash Join

Edwin Desouza

11/13/2019 12:36PM

MySQL 8.0: Understanding Hash Joins

Edwin Desouza

10/30/2019 11:06AM

Explain Analyze in MySQL 8

Edwin Desouza

10/28/2019 05:00PM

optimizing searches using aggregate data in join

118

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

Edwin Desouza

10/17/2019 07:15AM

MySQL 8.0.18 Maintenance Release is Generally Available

Edwin Desouza

10/14/2019 01:06PM

Slow Query

228

Deepak Nirmul

06/21/2019 04:47AM

Re: Slow Query

Peter Brawley

06/21/2019 10:17AM

Re: Slow Query

Deepak Nirmul

06/24/2019 02:18AM

Re: Slow Query

Peter Brawley

06/24/2019 09:56AM

Re: Slow Query

Deepak Nirmul

06/24/2019 10:15AM

Re: Slow Query

Peter Brawley

06/24/2019 10:45AM

Re: Slow Query

Gopal venkat

09/04/2019 11:47AM

Gopal, please don't hijack threads

Peter Brawley

09/04/2019 02:32PM

Re: Slow Query

marimuthu B

09/06/2019 05:59AM

Re: Slow Query

Peter Brawley

09/06/2019 09:57AM

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

112

Edwin Desouza

07/12/2019 11:13AM

setting an index for speed

160

Michael Peters

07/02/2019 04:56AM

Re: setting an index for speed

Peter Brawley

07/02/2019 12:29PM

Query optimization and indexing - Help needed

187

Pandit P

06/13/2019 06:41AM

Re: Query optimization and indexing - Help needed

Peter Brawley

06/13/2019 12:55PM

Re: Query optimization and indexing - Help needed

Pandit P

06/14/2019 12:01AM

Re: Query optimization and indexing - Help needed

Peter Brawley

06/14/2019 07:51AM

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

173

Ted Johnson

05/29/2019 02:12PM

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

Peter Brawley

05/29/2019 03:00PM

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

Ted Johnson

05/29/2019 04:41PM

CHECK constraints in MySQL

128

Edwin Desouza

05/14/2019 09:37AM

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

177

Edwin Desouza

04/10/2019 09:14AM

Comparing two columns on big table

173

Krzysztof Wróblewski

03/21/2019 03:24PM

Re: Comparing two columns on big table

102

Peter Brawley

03/21/2019 04:24PM

help with this query

186

sha fendi

03/16/2019 09:17PM

Re: help with this query

103

Peter Brawley

03/17/2019 11:04AM

MySQL Functional Indexes

158

Edwin Desouza

03/14/2019 09:49AM

MySQL 8.0: Query analytics [CTEs, Window Functions]

166

Edwin Desouza

03/09/2019 11:04PM

MySQL 8.0: Improvements to ROLLUP

162

Edwin Desouza

03/05/2019 11:53AM

MySQL 8.0: Window Functions for JSON

147

Edwin Desouza

02/21/2019 11:08AM

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

207

aaron chan

02/19/2019 09:00PM

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

Peter Brawley

02/20/2019 10:47AM

MySQL 8.0: New Index Features

222

Edwin Desouza

02/08/2019 11:18AM

MySQL 8.0: support for LATERAL derived tables

191

Edwin Desouza

01/31/2019 11:07AM

MySQL 8.0: Keywords

353

Edwin Desouza

01/10/2019 09:22PM

MySQL 8.0: Window Functions with Unusual Boundaries

279

Edwin Desouza

11/08/2018 02:42PM

More SQL in MySQL 8.0

530

Edwin Desouza

11/06/2018 07:28PM

MySQL 8.0: What Is New in Optimizer and Executor?

300

Edwin Desouza

11/01/2018 11:10AM

Optimizer Improvements in MySQL 8.0

267

Edwin Desouza

10/31/2018 09:31PM

Indexes are not working after restoring dump

333

Amit K

09/27/2018 11:25AM

Re: Indexes are not working after restoring dump

218

Amit K

09/27/2018 01:39PM

Re: Indexes are not working after restoring dump

202

Amit K

09/27/2018 01:45PM

Re: Indexes are not working after restoring dump

189

Øystein Grøvlen

09/28/2018 12:21AM

Re: Indexes are not working after restoring dump

221

Peter Brawley

09/27/2018 07:14PM

Re: Indexes are not working after restoring dump

210

Amit K

09/27/2018 08:31PM

Re: Indexes are not working after restoring dump

192

Peter Brawley

09/28/2018 11:08AM

Optimizer produces incorrect resultset

269

J Barchan

09/27/2018 09:35AM

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

302

Edwin Desouza

09/07/2018 10:34AM

Where Clause Optimization

397

Mohammed Yehia El Sayed Abdoh

08/31/2018 06:47AM

Re: Where Clause Optimization

197

Peter Brawley

08/31/2018 01:55PM

Re: Where Clause Optimization

199

Mohammed Yehia El Sayed Abdoh

08/31/2018 03:08PM

Re: Where Clause Optimization

207

Øystein Grøvlen

09/03/2018 02:45AM

long execution time of all requests, drop base

552

Уррик Зарик

06/10/2018 06:10AM

Re: long execution time of all requests, drop base

234

Peter Brawley

06/10/2018 12:24PM

Re: long execution time of all requests, drop base

211

Уррик Зарик

06/10/2018 12:40PM

Re: long execution time of all requests, drop base

240

Peter Brawley

06/10/2018 02:24PM

Re: long execution time of all requests, drop base

267

Urri Zar

06/11/2018 12:09AM

Re: long execution time of all requests, drop base

190

Urri Zar

06/12/2018 10:25AM

Re: long execution time of all requests, drop base

214

Peter Brawley

06/12/2018 10:27AM

Re: long execution time of all requests, drop base

280

Urri Zar

06/12/2018 10:34AM

Re: long execution time of all requests, drop base

315

Peter Brawley

06/12/2018 12:00PM

Create index for Join some table in MySQL

370

Kenny Nguyen

05/20/2018 10:51PM

Re: Create index for Join some table in MySQL

241

Øystein Grøvlen

05/30/2018 12:50AM

Determine time taken by commit statement after insert or update statement

461

Priya Pawar

05/07/2018 02:01AM

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

268

Jesús Uzcanga

05/07/2018 08:43AM

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

233

Priya Pawar

05/08/2018 12:03AM

MySQL 8.0: One Giant Leap For SQL

281

Edwin Desouza

04/25/2018 10:14AM

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

488

li zheng

03/25/2018 07:27AM

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

295

li zheng

03/25/2018 08:38AM

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

247

Peter Brawley

03/25/2018 01:59PM

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

291

Peter Brawley

03/25/2018 03:04PM

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

263

li zheng

03/25/2018 08:13PM

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

280

Peter Brawley

03/25/2018 10:03PM

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

241

li zheng

03/26/2018 02:41AM

optimize range query(using between, group by and order by)

876

Özgen Erbakan

03/20/2018 02:34AM

Re: optimize range query(using between, group by and order by)

461

Øystein Grøvlen

03/20/2018 03:52AM

Slow DELETE-Statement since update on 5.7

811

engram GmbH

03/19/2018 07:51AM

Re: Slow DELETE-Statement since update on 5.7

382

Peter Brawley

03/19/2018 11:40AM

Re: Slow DELETE-Statement since update on 5.7

394

Øystein Grøvlen

03/19/2018 01:15PM

Re: Slow DELETE-Statement since update on 5.7

408

engram GmbH

03/20/2018 02:09AM

Optimizer choosing wrong index

319

Daniel Kasak

03/19/2018 05:48PM

MySQL 8.0: Histograms

315

Edwin Desouza

03/01/2018 02:27PM

Indexing a small table increases the query cost

546

Aram Mirzadeh

02/28/2018 04:52AM

Re: Indexing a small table increases the query cost

254

Peter Brawley

02/28/2018 08:50AM

Re: Indexing a small table increases the query cost

288

Aram Mirzadeh

02/28/2018 11:24AM

Re: Indexing a small table increases the query cost

255

Aram Mirzadeh

02/28/2018 11:30AM

Re: Indexing a small table increases the query cost

238

Peter Brawley

02/28/2018 12:58PM

Re: Indexing a small table increases the query cost

305

Øystein Grøvlen

03/01/2018 03:15AM

MySQL: Ranking techniques

368

Edwin Desouza

01/23/2018 11:23AM

MySQL 8.0: Row numbering, ranking: using Window Functions

380

Edwin Desouza

12/22/2017 11:41PM

My query take along time

561

Murawweh Daher

12/17/2017 07:18AM

Muranweh, please don't double-post

229

Peter Brawley

12/17/2017 09:48AM

MySQL 8.0: Query Optimizer Takes Data Buffering into Account

359

Edwin Desouza

12/07/2017 11:21AM

Compound index (pkey) not used when it should be

497

Dan Parker

11/29/2017 01:39PM

Re: Compound index (pkey) not used when it should be

331

Peter Brawley

11/29/2017 04:21PM

Re: Compound index (pkey) not used when it should be

320

Dan Parker

11/29/2017 04:38PM

Re: Compound index (pkey) not used when it should be

313

Peter Brawley

11/29/2017 05:16PM

Re: Compound index (pkey) not used when it should be

309

Dan Parker

11/29/2017 05:25PM

Re: Compound index (pkey) not used when it should be

315

Peter Brawley

11/29/2017 06:13PM

Re: Compound index (pkey) not used when it should be

328

Dan Parker

11/29/2017 06:23PM

Re: Compound index (pkey) not used when it should be

297

Peter Brawley

11/29/2017 07:46PM

Re: Compound index (pkey) not used when it should be

315

Dan Parker

11/30/2017 10:31AM

Re: Compound index (pkey) not used when it should be

306

Peter Brawley

12/01/2017 11:02AM

Re: Compound index (pkey) not used when it should be

303

Dan Parker

12/01/2017 11:05AM

Re: Compound index (pkey) not used when it should be

305

Peter Brawley

12/01/2017 11:19AM

Re: Compound index (pkey) not used when it should be

295

Dan Parker

12/01/2017 11:26AM

Re: Compound index (pkey) not used when it should be

308

Peter Brawley

12/01/2017 01:04PM

Re: Compound index (pkey) not used when it should be

314

Dan Parker

12/01/2017 01:10PM

Re: Compound index (pkey) not used when it should be

294

Peter Brawley

12/01/2017 05:01PM

Re: Compound index (pkey) not used when it should be

311

Øystein Grøvlen

12/01/2017 10:10AM

Re: Compound index (pkey) not used when it should be

304

Dan Parker

12/01/2017 10:36AM

Confirmation on possible parser bug

492

Patrick Meredith

11/27/2017 10:47AM

Re: Confirmation on possible parser bug

243

Peter Brawley

11/30/2017 11:20AM

Source code question related to sql_optimizer.cc line 8583

533

Petru-Florin Mihancea

11/28/2017 04:20AM

Re: Source code question related to sql_optimizer.cc line 8583

274

Øystein Grøvlen

11/28/2017 07:01AM

MySQL 8.0: Optimization to skip index dives with FORCE INDEX.

511

Edwin Desouza

11/17/2017 09:50AM

Is Union Queries run in Parallel form or not.

621

Azeem Haider

10/17/2017 11:40PM

Re: Is Union Queries run in Parallel form or not.

322

Peter Brawley

10/18/2017 08:32AM

Re: Is Union Queries run in Parallel form or not.

373

Azeem Haider

10/18/2017 10:43PM

Re: Is Union Queries run in Parallel form or not.

307

Peter Brawley

10/18/2017 10:55PM

Re: Is Union Queries run in Parallel form or not.

373

Øystein Grøvlen

10/19/2017 03:02AM

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

This topic has been moved.: My query take along time

Murawweh Daher

12/17/2017 09:37AM

This topic has been moved.: Is Union Queries run in Parallel form or not.

Azeem Haider

10/18/2017 10:56PM

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.