MySQL :: MySQL Forums :: Optimizer & Parser

New Topic

Pages:

« 1 2 3 4 5

...

19 »

Subject

Views

Written By

Posted

MySQL 8.0.1: [Recursive] Common Table Expressions in MySQL (CTEs), Part Four – depth-first or breadth-first traversal, transitive closure, cycle avoidance

1,677

Edwin Desouza

05/23/2017 11:01AM

MySQL Index Advisor for SQL Tuning

5,562

Chaitanya Challa

05/10/2017 09:12PM

Re: MySQL Index Advisor for SQL Tuning

3,302

Edwin Desouza

05/10/2017 10:57PM

Re: MySQL Index Advisor for SQL Tuning

1,932

Chaitanya Challa

05/11/2017 08:08AM

MySQL 8.0: CTEs Recursive Query Throwdown

1,951

Edwin Desouza

05/05/2017 06:14PM

MySQL 8.0: GROUPING function

1,151

Edwin Desouza

05/02/2017 10:37AM

How to Analyze and Tune MySQL Queries for Better Performance

1,101

Edwin Desouza

04/27/2017 11:32AM

MySQL 8.0: Optimizer: What's New

1,280

Edwin Desouza

04/27/2017 11:31AM

MySQL 8.0 Optimizer Guide

1,399

Edwin Desouza

04/27/2017 11:30AM

MySQL 8.0.1: Using SKIP LOCKED and NOWAIT to handle hot rows

1,467

Edwin Desouza

04/12/2017 11:57AM

MySQL 8.0: Improved performance with CTE

1,282

Edwin Desouza

04/12/2017 11:57AM

MySQL 5.7: What to Do When the Optimizer Overestimates the Condition Filtering Effect

1,205

Edwin Desouza

03/24/2017 11:30AM

prepare don't work for optimize statement

1,450

Long WU

03/22/2017 12:30AM

Re: prepare don't work for optimize statement

874

Øystein Grøvlen

03/22/2017 01:34AM

MySQL 5.7: Improved JOIN Order by Taking Condition Filter Effect into Account

1,458

Edwin Desouza

03/17/2017 02:49PM

Improve search when using IN() ORDER BY PRIMARY and LIMIT

2,021

jon sans

02/11/2017 07:17AM

Re: Improve search when using IN() ORDER BY PRIMARY and LIMIT

712

jon sans

02/11/2017 07:29AM

Re: Improve search when using IN() ORDER BY PRIMARY and LIMIT

864

Øystein Grøvlen

02/13/2017 05:58AM

MySQL Performance Tuning: Optimizer Hints

1,290

Edwin Desouza

02/04/2017 09:09PM

Hiw to fast delete rows from table in relation?

1,574

Andrzej Borucki

01/22/2017 02:21AM

Re: Hiw to fast delete rows from table in relation?

897

Andrzej Borucki

01/22/2017 03:39AM

Re: Hiw to fast delete rows from table in relation?

818

Andrzej Borucki

01/22/2017 04:03AM

Query not always using indexes

3,278

K DBA

01/06/2017 05:48AM

Re: Query not always using indexes

1,157

Peter Brawley

01/06/2017 12:28PM

Re: Query not always using indexes

1,215

K DBA

01/09/2017 05:18AM

Re: Query not always using indexes

1,057

Øystein Grøvlen

01/09/2017 02:30AM

Optimize subquery, replace IN() with JOIN

3,373

Miron jajtic

11/15/2016 02:37PM

Re: Optimize subquery, replace IN() with JOIN

1,184

Peter Brawley

11/15/2016 03:34PM

Re: Optimize subquery, replace IN() with JOIN

1,464

Miron jajtic

11/15/2016 04:25PM

Re: Optimize subquery, replace IN() with JOIN

1,162

Rick James

11/17/2016 08:11PM

Re: Optimize subquery, replace IN() with JOIN

1,134

Peter Brawley

11/22/2016 02:44PM

Re: Optimize subquery, replace IN() with JOIN

1,198

Miron jajtic

11/16/2016 04:03AM

Re: Optimize subquery, replace IN() with JOIN

1,189

Peter Brawley

11/16/2016 12:51PM

Re: Optimize subquery, replace IN() with JOIN

1,428

Miron jajtic

11/16/2016 03:22PM

Re: Optimize subquery, replace IN() with JOIN

1,148

Peter Brawley

11/16/2016 04:44PM

Re: Optimize subquery, replace IN() with JOIN

995

sahar gull

12/27/2016 05:32AM

Re: Optimize subquery, replace IN() with JOIN

1,072

Øystein Grøvlen

11/16/2016 01:50AM

Re: Optimize subquery, replace IN() with JOIN

1,155

Miron jajtic

11/16/2016 04:01AM

Re: Optimize subquery, replace IN() with JOIN

1,421

Øystein Grøvlen

11/16/2016 06:23AM

Improved Query Performance by Using Derived Table instead of IN-subquery

1,337

Edwin Desouza

12/23/2016 08:50AM

primary key vs covered index

1,910

marcin kot

11/30/2016 09:55AM

Re: primary key vs covered index

1,030

Øystein Grøvlen

12/01/2016 01:39AM

Re: primary key vs covered index

996

marcin kot

12/01/2016 03:38AM

Re: primary key vs covered index

1,026

Øystein Grøvlen

12/01/2016 03:57AM

Re: primary key vs covered index

943

marcin kot

12/01/2016 04:16AM

Re: primary key vs covered index

913

Øystein Grøvlen

12/01/2016 04:25AM

MySQL 8.0: Refactoring and Improving the Parser

1,409

Edwin Desouza

11/22/2016 10:58AM

MySQL subquery

1,730

harry sheng

10/27/2016 02:51PM

Re: MySQL subquery

1,031

Øystein Grøvlen

10/28/2016 01:03AM

Re: MySQL subquery

967

harry sheng

11/06/2016 08:50PM

Re: MySQL subquery

1,022

Øystein Grøvlen

11/07/2016 01:39AM

How to Analyze and Tune MySQL Queries for Better Performance

1,498

Edwin Desouza

10/21/2016 09:58AM

Index on timestamp

8,630

Adeline M

10/14/2016 08:47AM

Re: Index on timestamp

3,496

Rick James

10/16/2016 04:40PM

MySQL 8.0: Descending Indexes

1,695

Edwin Desouza

10/12/2016 10:00AM

Pivot table with dynamic columns

7,951

Aram Mirzadeh

09/30/2016 06:03PM

Re: Pivot table with dynamic columns

2,891

Rick James

10/03/2016 03:40PM

inner join vs left join - huge performance difference

13,845

michael cook

07/06/2016 09:32AM

Re: inner join vs left join - huge performance difference

3,468

Peter Brawley

07/06/2016 12:00PM

Re: inner join vs left join - huge performance difference

2,408

michael cook

07/06/2016 12:18PM

Re: inner join vs left join - huge performance difference

1,967

michael cook

07/06/2016 12:29PM

Re: inner join vs left join - huge performance difference

1,740

Peter Brawley

07/06/2016 12:36PM

Re: inner join vs left join - huge performance difference

1,877

michael cook

07/06/2016 12:44PM

Re: inner join vs left join - huge performance difference

1,783

michael cook

07/06/2016 01:51PM

Re: inner join vs left join - huge performance difference

1,806

Peter Brawley

07/06/2016 02:32PM

Re: inner join vs left join - huge performance difference

1,533

michael cook

07/06/2016 02:41PM

Re: inner join vs left join - huge performance difference

1,578

Rick James

07/08/2016 11:58PM

Re: inner join vs left join - huge performance difference

1,693

Peter Brawley

07/09/2016 09:54AM

Re: inner join vs left join - huge performance difference

1,921

Isabella Swan

09/27/2016 07:13AM

This topic has been moved.: INSERT AfTER LEFT JOIN creates duplicate records

Brad Liu

09/20/2016 02:09PM

MySQL 8.0: Invisible Indexes

2,018

Edwin Desouza

09/20/2016 09:21AM

Preparse Query Rewrite Plugin DLL

2,771

Francois Haddad

08/12/2016 05:16PM

Re: Preparse Query Rewrite Plugin DLL

1,057

Georgi Kodinov

09/08/2016 02:23AM

Re: Preparse Query Rewrite Plugin DLL

1,498

Francois Haddad

09/14/2016 07:04PM

Re: Preparse Query Rewrite Plugin DLL

1,124

Tor Didriksen

09/15/2016 01:40AM

Re: Preparse Query Rewrite Plugin DLL

1,311

Francois Haddad

09/15/2016 11:34AM

Preparse Query Rewrite Plugin DLL

2,294

Francois Haddad

06/03/2016 12:41PM

Re: Preparse Query Rewrite Plugin DLL

948

Francois Haddad

06/03/2016 03:13PM

Re: Preparse Query Rewrite Plugin DLL

907

Georgi Kodinov

06/28/2016 02:12AM

Re: Preparse Query Rewrite Plugin DLL

891

Francois Haddad

08/12/2016 05:13PM

why the two query has a different execute plan?

3,748

h h

08/22/2016 02:55AM

Re: why the two query has a different execute plan?

943

Øystein Grøvlen

08/22/2016 05:08AM

Re: why the two query has a different execute plan?

910

Rick James

08/26/2016 02:29PM

This topic has been moved.: Preparse Query Rewrite Plugin DLL

945

Francois Haddad

08/15/2016 09:28AM

how to optimize this sql?

1,771

h h

07/07/2016 07:38PM

Re: how to optimize this sql?

1,231

Peter Brawley

07/08/2016 10:59AM

Re: how to optimize this sql?

1,253

h h

07/12/2016 09:01PM

Re: how to optimize this sql?

1,146

Rick James

07/09/2016 11:04PM

Re: how to optimize this sql?

1,075

h h

07/12/2016 09:08PM

Re: how to optimize this sql?

1,046

Rick James

07/14/2016 12:52PM

Indexing for date column for range query

1,600

duc minh

07/05/2016 11:04PM

Re: Indexing for date column for range query

919

Rick James

07/09/2016 10:47PM

Help with partially unique index

2,110

El T

06/22/2016 04:44AM

Re: Help with partially unique index

1,061

Rick James

06/25/2016 10:45PM

Re: Help with partially unique index

1,140

El T

07/02/2016 03:33PM

Re: Help with partially unique index

938

Rick James

07/04/2016 12:50PM

Explain plans for InnoDB and Memory Engines

1,881

Jagan Kumar

05/02/2016 03:15PM

Re: Explain plans for InnoDB and Memory Engines

907

Peter Brawley

05/02/2016 09:23PM

Re: Explain plans for InnoDB and Memory Engines

1,099

Øystein Grøvlen

05/04/2016 05:17AM

Re: Explain plans for InnoDB and Memory Engines

992

Rick James

05/05/2016 10:18PM

MySQL Query Rewrite Plugins

1,567

Edwin Desouza

02/02/2016 09:48PM

why left join can not use unique index?

2,981

h h

12/07/2015 08:30PM

Re: why left join can not use unique index?

1,224

Rick James

12/08/2015 08:46PM

Re: why left join can not use unique index?

1,097

h h

12/11/2015 03:20AM

Re: why left join can not use unique index?

1,195

Rick James

12/15/2015 11:08AM

This topic has been moved.: A stored function to remove diacritics and other chars

Marc Elbet

12/11/2015 03:50AM

prepared statement query takes 3s for a few hundred lines - query issue

1,809

Michael W.

11/16/2015 11:14AM

Re: prepared statement query takes 3s for a few hundred lines - query issue

1,108

Rick James

11/30/2015 08:09PM

Re: prepared statement query takes 3s for a few hundred lines - query issue

1,207

Michael W.

12/01/2015 07:10AM

Re: prepared statement query takes 3s for a few hundred lines - query issue

1,261

Rick James

12/07/2015 01:17AM

Why not use index

2,300

zhang peng

11/08/2015 11:14PM

Re: Why not use index

1,070

Peter Brawley

11/09/2015 11:42AM

Re: Why not use index

1,099

zhang peng

11/11/2015 12:17AM

Re: Why not use index

1,189

Øystein Grøvlen

11/10/2015 10:35AM

Re: Why not use index

1,264

zhang peng

11/11/2015 12:15AM

Re: Why not use index

1,207

Øystein Grøvlen

11/11/2015 03:40AM

Re: Why not use index

1,448

zhang peng

11/11/2015 07:29PM

Re: Why not use index

1,019

Peter Brawley

11/11/2015 11:00PM

Re: Why not use index

1,194

Øystein Grøvlen

11/12/2015 01:48AM

Re: Why not use index

1,139

zhang peng

11/16/2015 12:17AM

Google Update Optimizer system

2,086

Anik Bhowmik

11/09/2015 09:35PM

Re: Google Update Optimizer system

1,256

Peter Brawley

11/09/2015 10:12PM

Re: Google Update Optimizer system

1,025

Jonathan Stephens

11/10/2015 01:02AM

Normalize dump table

3,130

Jose Valle

10/11/2015 08:37PM

Re: Normalize dump table

1,078

Jose Valle

10/11/2015 08:42PM

Re: Normalize dump table

1,347

Antonio Valle

10/13/2015 01:41PM

Re: Normalize dump table

1,229

Rick James

10/17/2015 07:15PM

optimize query for index using between and group by

2,975

Raghavendra raghu

08/28/2015 03:21AM

Re: optimize query for index using between and group by

1,690

Rick James

08/29/2015 09:56AM

Re: optimize query for index using between and group by

1,189

Raghavendra raghu

08/31/2015 02:34AM

Parsing in MySQL Workbench: the ANTLR age

2,171

Edwin Desouza

08/14/2015 10:16AM

MySQL Optimizer: Hints

2,136

Edwin Desouza

07/29/2015 10:07AM

Index not working for date field used in between query

5,932

Shrinivasa rao

07/22/2015 11:48PM

Re: Index not working for date field used in between query

2,405

Rick James

07/26/2015 08:28AM

MyISAM using 'wrong' index

2,356

Danny Stommen

06/08/2015 04:14AM