MySQL Forums
Forum List  »  Optimizer & Parser

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

Subject
Views
Written By
Posted
Create index for Join some table in MySQL  
576
Kenny Nguyen
05/20/2018 10:51PM
Re: Create index for Join some table in MySQL  
352
Øystein Grøvlen
05/30/2018 12:50AM
Determine time taken by commit statement after insert or update statement  
685
Priya Pawar
05/07/2018 02:01AM
Re: Determine time taken by commit statement after insert or update statement  
388
Jesús Uzcanga
05/07/2018 08:43AM
Re: Determine time taken by commit statement after insert or update statement  
317
Priya Pawar
05/08/2018 12:03AM
MySQL 8.0: One Giant Leap For SQL  
405
Edwin Desouza
04/25/2018 10:14AM
how to speed up query on a table with over 20million records?  
847
li zheng
03/25/2018 07:27AM
Re: how to speed up query on a table with over 20million records?  
424
li zheng
03/25/2018 08:38AM
Re: how to speed up query on a table with over 20million records?  
340
Peter Brawley
03/25/2018 01:59PM
Re: how to speed up query on a table with over 20million records?  
409
Peter Brawley
03/25/2018 03:04PM
Re: how to speed up query on a table with over 20million records?  
371
li zheng
03/25/2018 08:13PM
Re: how to speed up query on a table with over 20million records?  
391
Peter Brawley
03/25/2018 10:03PM
Re: how to speed up query on a table with over 20million records?  
337
li zheng
03/26/2018 02:41AM
optimize range query(using between, group by and order by)  
1,241
Özgen Erbakan
03/20/2018 02:34AM
Re: optimize range query(using between, group by and order by)  
554
Øystein Grøvlen
03/20/2018 03:52AM
Slow DELETE-Statement since update on 5.7  
1,196
engram GmbH
03/19/2018 07:51AM
Re: Slow DELETE-Statement since update on 5.7  
519
Peter Brawley
03/19/2018 11:40AM
Re: Slow DELETE-Statement since update on 5.7  
537
Øystein Grøvlen
03/19/2018 01:15PM
Re: Slow DELETE-Statement since update on 5.7  
533
engram GmbH
03/20/2018 02:09AM
Optimizer choosing wrong index  
455
Daniel Kasak
03/19/2018 05:48PM
MySQL 8.0: Histograms  
417
Edwin Desouza
03/01/2018 02:27PM
Indexing a small table increases the query cost  
813
Aram Mirzadeh
02/28/2018 04:52AM
Re: Indexing a small table increases the query cost  
362
Peter Brawley
02/28/2018 08:50AM
Re: Indexing a small table increases the query cost  
395
Aram Mirzadeh
02/28/2018 11:24AM
Re: Indexing a small table increases the query cost  
328
Aram Mirzadeh
02/28/2018 11:30AM
Re: Indexing a small table increases the query cost  
320
Peter Brawley
02/28/2018 12:58PM
Re: Indexing a small table increases the query cost  
392
Øystein Grøvlen
03/01/2018 03:15AM
MySQL: Ranking techniques  
493
Edwin Desouza
01/23/2018 11:23AM
MySQL 8.0: Row numbering, ranking: using Window Functions  
485
Edwin Desouza
12/22/2017 11:41PM
My query take along time  
733
Murawweh Daher
12/17/2017 07:18AM
Muranweh, please don't double-post  
292
Peter Brawley
12/17/2017 09:48AM
MySQL 8.0: Query Optimizer Takes Data Buffering into Account  
471
Edwin Desouza
12/07/2017 11:21AM
Compound index (pkey) not used when it should be  
740
Dan Parker
11/29/2017 01:39PM
Re: Compound index (pkey) not used when it should be  
424
Peter Brawley
11/29/2017 04:21PM
Re: Compound index (pkey) not used when it should be  
410
Dan Parker
11/29/2017 04:38PM
Re: Compound index (pkey) not used when it should be  
412
Peter Brawley
11/29/2017 05:16PM
Re: Compound index (pkey) not used when it should be  
405
Dan Parker
11/29/2017 05:25PM
Re: Compound index (pkey) not used when it should be  
416
Peter Brawley
11/29/2017 06:13PM
Re: Compound index (pkey) not used when it should be  
427
Dan Parker
11/29/2017 06:23PM
Re: Compound index (pkey) not used when it should be  
388
Peter Brawley
11/29/2017 07:46PM
Re: Compound index (pkey) not used when it should be  
425
Dan Parker
11/30/2017 10:31AM
Re: Compound index (pkey) not used when it should be  
390
Peter Brawley
12/01/2017 11:02AM
Re: Compound index (pkey) not used when it should be  
393
Dan Parker
12/01/2017 11:05AM
Re: Compound index (pkey) not used when it should be  
389
Peter Brawley
12/01/2017 11:19AM
Re: Compound index (pkey) not used when it should be  
408
Dan Parker
12/01/2017 11:26AM
Re: Compound index (pkey) not used when it should be  
413
Peter Brawley
12/01/2017 01:04PM
Re: Compound index (pkey) not used when it should be  
429
Dan Parker
12/01/2017 01:10PM
Re: Compound index (pkey) not used when it should be  
383
Peter Brawley
12/01/2017 05:01PM
Re: Compound index (pkey) not used when it should be  
398
Øystein Grøvlen
12/01/2017 10:10AM
Re: Compound index (pkey) not used when it should be  
409
Dan Parker
12/01/2017 10:36AM
Confirmation on possible parser bug  
622
Patrick Meredith
11/27/2017 10:47AM
Re: Confirmation on possible parser bug  
309
Peter Brawley
11/30/2017 11:20AM
Source code question related to sql_optimizer.cc line 8583  
668
Petru-Florin Mihancea
11/28/2017 04:20AM
Re: Source code question related to sql_optimizer.cc line 8583  
360
Øystein Grøvlen
11/28/2017 07:01AM
MySQL 8.0: Optimization to skip index dives with FORCE INDEX.  
611
Edwin Desouza
11/17/2017 09:50AM
Is Union Queries run in Parallel form or not.  
786
Azeem Haider
10/17/2017 11:40PM
Re: Is Union Queries run in Parallel form or not.  
405
Peter Brawley
10/18/2017 08:32AM
Re: Is Union Queries run in Parallel form or not.  
535
Azeem Haider
10/18/2017 10:43PM
Re: Is Union Queries run in Parallel form or not.  
406
Peter Brawley
10/18/2017 10:55PM
Re: Is Union Queries run in Parallel form or not.  
465
Øystein Grøvlen
10/19/2017 03:02AM
MySQL 8.0: Window Functions  
489
Edwin Desouza
10/04/2017 06:03PM
Grammer Rule for Parenthesis in Select Statement  
669
Sushant Choudhary
09/21/2017 12:47PM
Please don't duplicate posts  
395
Peter Brawley
09/21/2017 12:49PM
Help with explain on query  
576
Alex Titley
08/16/2017 09:09AM
Re: Help with explain on query  
323
Peter Brawley
08/16/2017 10:07AM
Optimizer Stablility  
558
Chris Reston
08/16/2017 12:56AM
Re: Optimizer Stablility  
366
Øystein Grøvlen
08/16/2017 02:19AM
Way to avoid fragmentation of MySQL tables  
546
Priya Pawar
07/30/2017 11:01AM
Re: Way to avoid fragmentation of MySQL tables  
460
Peter Brawley
07/30/2017 04:41PM
Re: Way to avoid fragmentation of MySQL tables  
352
Priya Pawar
07/30/2017 11:10PM
MySQL 8.0.2: Introducing Window Functions  
520
Edwin Desouza
07/18/2017 10:33AM
Can anyone help speed up this query?  
645
Search Team
06/21/2017 11:07AM
Re: Can anyone help speed up this query?  
403
Peter Brawley
06/21/2017 02:53PM
Re: Can anyone help speed up this query?  
416
Search Team
06/22/2017 09:15AM
Re: Can anyone help speed up this query?  
411
Peter Brawley
06/22/2017 12:54PM
Re: Can anyone help speed up this query?  
380
Search Team
06/23/2017 07:50AM
Re: Can anyone help speed up this query?  
329
Peter Brawley
06/23/2017 11:14AM
Re: Can anyone help speed up this query?  
393
Øystein Grøvlen
06/22/2017 01:18AM
Re: Can anyone help speed up this query?  
406
Search Team
06/22/2017 09:56AM
Re: Can anyone help speed up this query?  
399
Øystein Grøvlen
06/23/2017 12:53AM
Is there a better ANTLR grammar file for MySQL ?  
2,258
Bill Nicholson
05/28/2017 05:07PM
Re: Is there a better ANTLR grammar file for MySQL ?  
798
Edwin Desouza
05/29/2017 11:43PM
Re: Is there a better ANTLR grammar file for MySQL ?  
718
Edwin Desouza
05/30/2017 07:57AM
MySQL 8.0.1: [Recursive] Common Table Expressions in MySQL (CTEs), Part Four – depth-first or breadth-first traversal, transitive closure, cycle avoidance  
808
Edwin Desouza
05/23/2017 11:01AM
MySQL Index Advisor for SQL Tuning  
2,983
Chaitanya Challa
05/10/2017 09:12PM
Re: MySQL Index Advisor for SQL Tuning  
1,851
Edwin Desouza
05/10/2017 10:57PM
Re: MySQL Index Advisor for SQL Tuning  
1,083
Chaitanya Challa
05/11/2017 08:08AM
MySQL 8.0: CTEs Recursive Query Throwdown  
1,260
Edwin Desouza
05/05/2017 06:14PM
MySQL 8.0: GROUPING function  
524
Edwin Desouza
05/02/2017 10:37AM
How to Analyze and Tune MySQL Queries for Better Performance  
546
Edwin Desouza
04/27/2017 11:32AM
MySQL 8.0: Optimizer: What's New  
600
Edwin Desouza
04/27/2017 11:31AM
MySQL 8.0 Optimizer Guide  
684
Edwin Desouza
04/27/2017 11:30AM
MySQL 8.0.1: Using SKIP LOCKED and NOWAIT to handle hot rows  
646
Edwin Desouza
04/12/2017 11:57AM
MySQL 8.0: Improved performance with CTE  
575
Edwin Desouza
04/12/2017 11:57AM
MySQL 5.7: What to Do When the Optimizer Overestimates the Condition Filtering Effect  
559
Edwin Desouza
03/24/2017 11:30AM
prepare don't work for optimize statement  
755
Long WU
03/22/2017 12:30AM
Re: prepare don't work for optimize statement  
365
Øystein Grøvlen
03/22/2017 01:34AM
MySQL 5.7: Improved JOIN Order by Taking Condition Filter Effect into Account  
652
Edwin Desouza
03/17/2017 02:49PM
Improve search when using IN() ORDER BY PRIMARY and LIMIT  
989
jon sans
02/11/2017 07:17AM
Re: Improve search when using IN() ORDER BY PRIMARY and LIMIT  
339
jon sans
02/11/2017 07:29AM
Re: Improve search when using IN() ORDER BY PRIMARY and LIMIT  
432
Øystein Grøvlen
02/13/2017 05:58AM
MySQL Performance Tuning: Optimizer Hints  
585
Edwin Desouza
02/04/2017 09:09PM
Hiw to fast delete rows from table in relation?  
785
Andrzej Borucki
01/22/2017 02:21AM
Re: Hiw to fast delete rows from table in relation?  
421
Andrzej Borucki
01/22/2017 03:39AM
Re: Hiw to fast delete rows from table in relation?  
416
Andrzej Borucki
01/22/2017 04:03AM
Query not always using indexes  
1,667
K DBA
01/06/2017 05:48AM
Re: Query not always using indexes  
562
Peter Brawley
01/06/2017 12:28PM
Re: Query not always using indexes  
607
K DBA
01/09/2017 05:18AM
Re: Query not always using indexes  
575
Øystein Grøvlen
01/09/2017 02:30AM
Optimize subquery, replace IN() with JOIN  
1,565
Miron jajtic
11/15/2016 02:37PM
Re: Optimize subquery, replace IN() with JOIN  
651
Peter Brawley
11/15/2016 03:34PM
Re: Optimize subquery, replace IN() with JOIN  
737
Miron jajtic
11/15/2016 04:25PM
Re: Optimize subquery, replace IN() with JOIN  
652
Rick James
11/17/2016 08:11PM
Re: Optimize subquery, replace IN() with JOIN  
629
Peter Brawley
11/22/2016 02:44PM
Re: Optimize subquery, replace IN() with JOIN  
671
Miron jajtic
11/16/2016 04:03AM
Re: Optimize subquery, replace IN() with JOIN  
616
Peter Brawley
11/16/2016 12:51PM
Re: Optimize subquery, replace IN() with JOIN  
723
Miron jajtic
11/16/2016 03:22PM
Re: Optimize subquery, replace IN() with JOIN  
630
Peter Brawley
11/16/2016 04:44PM
Re: Optimize subquery, replace IN() with JOIN  
463
sahar gull
12/27/2016 05:32AM
Re: Optimize subquery, replace IN() with JOIN  
556
Øystein Grøvlen
11/16/2016 01:50AM
Re: Optimize subquery, replace IN() with JOIN  
597
Miron jajtic
11/16/2016 04:01AM
Re: Optimize subquery, replace IN() with JOIN  
663
Øystein Grøvlen
11/16/2016 06:23AM
Improved Query Performance by Using Derived Table instead of IN-subquery  
684
Edwin Desouza
12/23/2016 08:50AM
primary key vs covered index  
1,085
marcin kot
11/30/2016 09:55AM
Re: primary key vs covered index  
566
Øystein Grøvlen
12/01/2016 01:39AM
Re: primary key vs covered index  
572
marcin kot
12/01/2016 03:38AM
Re: primary key vs covered index  
602
Øystein Grøvlen
12/01/2016 03:57AM
Re: primary key vs covered index  
537
marcin kot
12/01/2016 04:16AM
Re: primary key vs covered index  
473
Øystein Grøvlen
12/01/2016 04:25AM
MySQL 8.0: Refactoring and Improving the Parser  
773
Edwin Desouza
11/22/2016 10:58AM
MySQL subquery  
939
harry sheng
10/27/2016 02:51PM
Re: MySQL subquery  
558
Øystein Grøvlen
10/28/2016 01:03AM
Re: MySQL subquery  
563
harry sheng
11/06/2016 08:50PM
Re: MySQL subquery  
600
Øystein Grøvlen
11/07/2016 01:39AM
How to Analyze and Tune MySQL Queries for Better Performance  
770
Edwin Desouza
10/21/2016 09:58AM
Index on timestamp  
6,880
Adeline M
10/14/2016 08:47AM
Re: Index on timestamp  
2,835
Rick James
10/16/2016 04:40PM
MySQL 8.0: Descending Indexes  
978
Edwin Desouza
10/12/2016 10:00AM
This topic has been moved.:  My query take along time  
0
Murawweh Daher
12/17/2017 09:37AM
This topic has been moved.:  Is Union Queries run in Parallel form or not.  
0
Azeem Haider
10/18/2017 10:56PM
This topic has been moved.:  Improve search when using IN() ORDER BY PRIMARY and LIMIT  
0
jon sans
02/11/2017 01:36PM
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.