MySQL Forums
Forum List  »  Optimizer & Parser

Advanced Search
New Topic
Pages:
« 1 2 3 4 5
...
18 »

Subject
Views
Written By
Posted
Hiw to fast delete rows from table in relation?  
528
Andrzej Borucki
01/22/2017 02:21AM
Re: Hiw to fast delete rows from table in relation?  
273
Andrzej Borucki
01/22/2017 03:39AM
Re: Hiw to fast delete rows from table in relation?  
279
Andrzej Borucki
01/22/2017 04:03AM
Query not always using indexes  
819
K DBA
01/06/2017 05:48AM
Re: Query not always using indexes  
326
Peter Brawley
01/06/2017 12:28PM
Re: Query not always using indexes  
402
K DBA
01/09/2017 05:18AM
Re: Query not always using indexes  
382
Øystein Grøvlen
01/09/2017 02:30AM
Optimize subquery, replace IN() with JOIN  
876
Miron jajtic
11/15/2016 02:37PM
Re: Optimize subquery, replace IN() with JOIN  
396
Peter Brawley
11/15/2016 03:34PM
Re: Optimize subquery, replace IN() with JOIN  
447
Miron jajtic
11/15/2016 04:25PM
Re: Optimize subquery, replace IN() with JOIN  
468
Rick James
11/17/2016 08:11PM
Re: Optimize subquery, replace IN() with JOIN  
410
Peter Brawley
11/22/2016 02:44PM
Re: Optimize subquery, replace IN() with JOIN  
457
Miron jajtic
11/16/2016 04:03AM
Re: Optimize subquery, replace IN() with JOIN  
407
Peter Brawley
11/16/2016 12:51PM
Re: Optimize subquery, replace IN() with JOIN  
477
Miron jajtic
11/16/2016 03:22PM
Re: Optimize subquery, replace IN() with JOIN  
428
Peter Brawley
11/16/2016 04:44PM
Re: Optimize subquery, replace IN() with JOIN  
344
sahar gull
12/27/2016 05:32AM
Re: Optimize subquery, replace IN() with JOIN  
388
Øystein Grøvlen
11/16/2016 01:50AM
Re: Optimize subquery, replace IN() with JOIN  
399
Miron jajtic
11/16/2016 04:01AM
Re: Optimize subquery, replace IN() with JOIN  
439
Øystein Grøvlen
11/16/2016 06:23AM
Improved Query Performance by Using Derived Table instead of IN-subquery  
544
Edwin Desouza
12/23/2016 08:50AM
primary key vs covered index  
760
marcin kot
11/30/2016 09:55AM
Re: primary key vs covered index  
396
Øystein Grøvlen
12/01/2016 01:39AM
Re: primary key vs covered index  
410
marcin kot
12/01/2016 03:38AM
Re: primary key vs covered index  
413
Øystein Grøvlen
12/01/2016 03:57AM
Re: primary key vs covered index  
403
marcin kot
12/01/2016 04:16AM
Re: primary key vs covered index  
364
Øystein Grøvlen
12/01/2016 04:25AM
MySQL 8.0: Refactoring and Improving the Parser  
615
Edwin Desouza
11/22/2016 10:58AM
MySQL subquery  
700
harry sheng
10/27/2016 02:51PM
Re: MySQL subquery  
375
Øystein Grøvlen
10/28/2016 01:03AM
Re: MySQL subquery  
410
harry sheng
11/06/2016 08:50PM
Re: MySQL subquery  
430
Øystein Grøvlen
11/07/2016 01:39AM
How to Analyze and Tune MySQL Queries for Better Performance  
584
Edwin Desouza
10/21/2016 09:58AM
Index on timestamp  
3,322
Adeline M
10/14/2016 08:47AM
Re: Index on timestamp  
1,459
Rick James
10/16/2016 04:40PM
MySQL 8.0: Descending Indexes  
798
Edwin Desouza
10/12/2016 10:00AM
Pivot table with dynamic columns  
2,719
Aram Mirzadeh
09/30/2016 06:03PM
Re: Pivot table with dynamic columns  
1,016
Rick James
10/03/2016 03:40PM
inner join vs left join - huge performance difference  
3,908
michael cook
07/06/2016 09:32AM
Re: inner join vs left join - huge performance difference  
1,126
Peter Brawley
07/06/2016 12:00PM
Re: inner join vs left join - huge performance difference  
740
michael cook
07/06/2016 12:18PM
Re: inner join vs left join - huge performance difference  
623
michael cook
07/06/2016 12:29PM
Re: inner join vs left join - huge performance difference  
564
Peter Brawley
07/06/2016 12:36PM
Re: inner join vs left join - huge performance difference  
658
michael cook
07/06/2016 12:44PM
Re: inner join vs left join - huge performance difference  
609
michael cook
07/06/2016 01:51PM
Re: inner join vs left join - huge performance difference  
600
Peter Brawley
07/06/2016 02:32PM
Re: inner join vs left join - huge performance difference  
473
michael cook
07/06/2016 02:41PM
Re: inner join vs left join - huge performance difference  
511
Rick James
07/08/2016 11:58PM
Re: inner join vs left join - huge performance difference  
605
Peter Brawley
07/09/2016 09:54AM
Re: inner join vs left join - huge performance difference  
656
Isabella Swan
09/27/2016 07:13AM
This topic has been moved.:  INSERT AfTER LEFT JOIN creates duplicate records  
10
Brad Liu
09/20/2016 02:09PM
MySQL 8.0: Invisible Indexes  
551
Edwin Desouza
09/20/2016 09:21AM
Preparse Query Rewrite Plugin DLL  
1,168
Francois Haddad
08/12/2016 05:16PM
Re: Preparse Query Rewrite Plugin DLL  
432
Georgi Kodinov
09/08/2016 02:23AM
Re: Preparse Query Rewrite Plugin DLL  
540
Francois Haddad
09/14/2016 07:04PM
Re: Preparse Query Rewrite Plugin DLL  
440
Tor Didriksen
09/15/2016 01:40AM
Re: Preparse Query Rewrite Plugin DLL  
490
Francois Haddad
09/15/2016 11:34AM
Preparse Query Rewrite Plugin DLL  
1,109
Francois Haddad
06/03/2016 12:41PM
Re: Preparse Query Rewrite Plugin DLL  
504
Francois Haddad
06/03/2016 03:13PM
Re: Preparse Query Rewrite Plugin DLL  
480
Georgi Kodinov
06/28/2016 02:12AM
Re: Preparse Query Rewrite Plugin DLL  
465
Francois Haddad
08/12/2016 05:13PM
why the two query has a different execute plan?  
1,029
h h
08/22/2016 02:55AM
Re: why the two query has a different execute plan?  
474
Øystein Grøvlen
08/22/2016 05:08AM
Re: why the two query has a different execute plan?  
381
Rick James
08/26/2016 02:29PM
This topic has been moved.:  Preparse Query Rewrite Plugin DLL  
373
Francois Haddad
08/15/2016 09:28AM
how to optimize this sql?  
733
h h
07/07/2016 07:38PM
Re: how to optimize this sql?  
487
Peter Brawley
07/08/2016 10:59AM
Re: how to optimize this sql?  
419
h h
07/12/2016 09:01PM
Re: how to optimize this sql?  
468
Rick James
07/09/2016 11:04PM
Re: how to optimize this sql?  
433
h h
07/12/2016 09:08PM
Re: how to optimize this sql?  
551
Rick James
07/14/2016 12:52PM
Indexing for date column for range query  
787
duc minh
07/05/2016 11:04PM
Re: Indexing for date column for range query  
481
Rick James
07/09/2016 10:47PM
Help with partially unique index  
907
El T
06/22/2016 04:44AM
Re: Help with partially unique index  
471
Rick James
06/25/2016 10:45PM
Re: Help with partially unique index  
496
El T
07/02/2016 03:33PM
Re: Help with partially unique index  
418
Rick James
07/04/2016 12:50PM
Explain plans for InnoDB and Memory Engines  
879
Jagan Kumar
05/02/2016 03:15PM
Re: Explain plans for InnoDB and Memory Engines  
412
Peter Brawley
05/02/2016 09:23PM
Re: Explain plans for InnoDB and Memory Engines  
536
Øystein Grøvlen
05/04/2016 05:17AM
Re: Explain plans for InnoDB and Memory Engines  
501
Rick James
05/05/2016 10:18PM
MySQL Query Rewrite Plugins  
888
Edwin Desouza
02/02/2016 09:48PM
why left join can not use unique index?  
1,594
h h
12/07/2015 08:30PM
Re: why left join can not use unique index?  
645
Rick James
12/08/2015 08:46PM
Re: why left join can not use unique index?  
596
h h
12/11/2015 03:20AM
Re: why left join can not use unique index?  
606
Rick James
12/15/2015 11:08AM
This topic has been moved.:  A stored function to remove diacritics and other chars  
20
Marc Elbet
12/11/2015 03:50AM
prepared statement query takes 3s for a few hundred lines - query issue  
1,041
Michael W.
11/16/2015 11:14AM
Re: prepared statement query takes 3s for a few hundred lines - query issue  
589
Rick James
11/30/2015 08:09PM
Re: prepared statement query takes 3s for a few hundred lines - query issue  
661
Michael W.
12/01/2015 07:10AM
Re: prepared statement query takes 3s for a few hundred lines - query issue  
590
Rick James
12/07/2015 01:17AM
Why not use index  
1,163
zhang peng
11/08/2015 11:14PM
Re: Why not use index  
570
Peter Brawley
11/09/2015 11:42AM
Re: Why not use index  
602
zhang peng
11/11/2015 12:17AM
Re: Why not use index  
588
Øystein Grøvlen
11/10/2015 10:35AM
Re: Why not use index  
696
zhang peng
11/11/2015 12:15AM
Re: Why not use index  
571
Øystein Grøvlen
11/11/2015 03:40AM
Re: Why not use index  
796
zhang peng
11/11/2015 07:29PM
Re: Why not use index  
584
Peter Brawley
11/11/2015 11:00PM
Re: Why not use index  
579
Øystein Grøvlen
11/12/2015 01:48AM
Re: Why not use index  
626
zhang peng
11/16/2015 12:17AM
Google Update Optimizer system  
1,089
Anik Bhowmik
11/09/2015 09:35PM
Re: Google Update Optimizer system  
590
Peter Brawley
11/09/2015 10:12PM
Re: Google Update Optimizer system  
593
Jonathan Stephens
11/10/2015 01:02AM
Normalize dump table  
1,606
Jose Valle
10/11/2015 08:37PM
Re: Normalize dump table  
565
Jose Valle
10/11/2015 08:42PM
Re: Normalize dump table  
638
Antonio Valle
10/13/2015 01:41PM
Re: Normalize dump table  
621
Rick James
10/17/2015 07:15PM
optimize query for index using between and group by  
1,654
Raghavendra raghu
08/28/2015 03:21AM
Re: optimize query for index using between and group by  
976
Rick James
08/29/2015 09:56AM
Re: optimize query for index using between and group by  
643
Raghavendra raghu
08/31/2015 02:34AM
Parsing in MySQL Workbench: the ANTLR age  
1,228
Edwin Desouza
08/14/2015 10:16AM
MySQL Optimizer: Hints  
1,335
Edwin Desouza
07/29/2015 10:07AM
Index not working for date field used in between query  
2,881
Shrinivasa rao
07/22/2015 11:48PM
Re: Index not working for date field used in between query  
1,156
Rick James
07/26/2015 08:28AM
MyISAM using 'wrong' index  
1,326
Danny Stommen
06/08/2015 04:14AM
Re: MyISAM using 'wrong' index  
745
Rick James
06/09/2015 11:53PM
Re: MyISAM using 'wrong' index  
842
Danny Stommen
06/30/2015 03:22AM
Re: MyISAM using 'wrong' index  
859
Rick James
07/02/2015 09:28PM
Re: MyISAM using 'wrong' index  
713
Danny Stommen
07/03/2015 03:16AM
Re: MyISAM using 'wrong' index  
768
Rick James
07/04/2015 11:10AM
Re: MyISAM using 'wrong' index  
707
Danny Stommen
07/07/2015 01:56AM
Re: MyISAM using 'wrong' index  
700
Edwin Desouza
07/07/2015 09:10AM
Need help understanding optimizer behavior in 5.6  
1,523
Aaron Craven
06/22/2015 08:30AM
Re: Need help understanding optimizer behavior in 5.6  
767
Aaron Craven
06/22/2015 08:31AM
Re: Need help understanding optimizer behavior in 5.6  
708
Rick James
06/23/2015 07:00PM
Re: Need help understanding optimizer behavior in 5.6  
717
Aaron Craven
06/24/2015 06:22AM
Re: Need help understanding optimizer behavior in 5.6  
661
Rick James
06/25/2015 11:37PM
Re: Need help understanding optimizer behavior in 5.6  
687
Aaron Craven
06/26/2015 06:56AM
Re: Need help understanding optimizer behavior in 5.6  
690
Øystein Grøvlen
06/30/2015 05:46AM
Re: Need help understanding optimizer behavior in 5.6  
1,075
Aaron Craven
06/30/2015 08:06AM
Re: Need help understanding optimizer behavior in 5.6  
695
Aaron Craven
06/30/2015 08:16AM
Re: Need help understanding optimizer behavior in 5.6  
765
Øystein Grøvlen
07/01/2015 03:49AM
Re: Need help understanding optimizer behavior in 5.6  
808
Aaron Craven
07/01/2015 06:48AM
Re: Need help understanding optimizer behavior in 5.6  
734
Edwin Desouza
07/01/2015 03:05PM
Re: Need help understanding optimizer behavior in 5.6  
732
Aaron Craven
07/02/2015 07:48AM
MySQL 5.7: Optimizer Trace and EXPLAIN FORMAT=JSON  
1,556
Edwin Desouza
05/25/2015 10:41AM
foreign key creation in a huge database  
1,546
Raffael Vendrametto
03/05/2015 04:05PM
Please do NOT duplicate posts  
794
Peter Brawley
03/05/2015 05:42PM
Query Taking 2.5hrs on 5.6.20 version  
1,897
ch srinivas
03/04/2015 01:30AM
Re: Query Taking 2.5hrs on 5.6.20 version  
857
Peter Brawley
03/04/2015 12:15PM
Re: Query Taking 2.5hrs on 5.6.20 version  
797
Rick James
03/04/2015 08:18PM
Query optimisation advice  
1,774
Paul Feely
01/08/2015 11:02PM
Re: Query optimisation advice  
918
Rick James
01/10/2015 01:22AM
Re: Query optimisation advice  
863
Paul Feely
01/11/2015 05:50PM
Re: Query optimisation advice  
896
Rick James
01/12/2015 10:35PM
actual Size calculation of mysql table (engine innodb)  
1,734
Afaque Ahmad Siddiqui
12/10/2014 09:38AM
Re: actual Size calculation of mysql table (engine innodb)  
903
Rick James
12/12/2014 08:32PM
Re: actual Size calculation of mysql table (engine innodb)  
925
Rick James
12/12/2014 08:36PM
MySQL cash optimization  
1,900
Sasha Katsman
11/27/2014 06:33AM
Re: MySQL cash optimization  
1,126
Peter Brawley
11/27/2014 04:34PM
Re: MySQL cash optimization  
823
Sasha Katsman
12/09/2014 04:33AM
Re: MySQL cache optimization  
782
Peter Brawley
12/09/2014 12:28PM
how to tune for optimizer_search_depth?  
1,879
jongse park
12/03/2014 12:13AM
Re: how to tune for optimizer_search_depth?  
1,197
Rick James
12/03/2014 11:33PM
Re: how to tune for optimizer_search_depth?  
1,166
Øystein Grøvlen
12/08/2014 05:32AM
MySQL Optimizer Cost Model  
1,696
Edwin Desouza
10/24/2014 10:37AM
Need help to create index on join statments  
1,823
Neil Sorathia
10/08/2014 06:24PM
Re: Need help to create index on join statments  
852
Neil Sorathia
10/09/2014 09:46AM
Re: Need help to create index on join statments  
950
Rick James
10/11/2014 01:37PM
Better Performance for JOINs Not Using Indexes  
1,593
Edwin Desouza
10/03/2014 01:48PM
A Multi-Table Trick to Speed up Single-Table UPDATE/DELETE Statements  
1,822
Edwin Desouza
10/03/2014 01:47PM
MySQL 5.7: Optimizer Hints + Query Rewrite  
1,763
Edwin Desouza
10/01/2014 08:53AM
Intermediate Query Results  
2,409
Ashwini Singh
09/12/2014 08:37AM
Re: Intermediate Query Results  
1,163
Rick James
09/13/2014 09:23PM
Re: Intermediate Query Results  
1,241
Øystein Grøvlen
09/15/2014 05:42AM
All records scanning using "LIKe" and "IN" operaters  
1,983
ch srinivas
06/28/2014 01:43PM
Re: All records scanning using "LIKe" and "IN" operaters  
995
Peter Brawley
06/28/2014 02:22PM
Re: All records scanning using "LIKe" and "IN" operaters  
931
Øystein Grøvlen
08/28/2014 03:47PM
Help me to optimize my sql query  
1,890
GAURAV JAIN
08/21/2014 07:29AM
Re: Help me to optimize my sql query  
933
Rick James
08/22/2014 06:50AM
Pages:
« 1 2 3 4 5
...
18 »

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.