MySQL Forums
Forum List  »  Optimizer & Parser

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

Subject
Views
Written By
Posted
More SQL in MySQL 8.0  
792
Edwin Desouza
11/06/2018 07:28PM
MySQL 8.0: What Is New in Optimizer and Executor?  
541
Edwin Desouza
11/01/2018 11:10AM
Optimizer Improvements in MySQL 8.0  
529
Edwin Desouza
10/31/2018 09:31PM
Indexes are not working after restoring dump  
842
Amit K
09/27/2018 11:25AM
Re: Indexes are not working after restoring dump  
477
Amit K
09/27/2018 01:39PM
Re: Indexes are not working after restoring dump  
416
Amit K
09/27/2018 01:45PM
Re: Indexes are not working after restoring dump  
442
Øystein Grøvlen
09/28/2018 12:21AM
Re: Indexes are not working after restoring dump  
464
Peter Brawley
09/27/2018 07:14PM
Re: Indexes are not working after restoring dump  
408
Amit K
09/27/2018 08:31PM
Re: Indexes are not working after restoring dump  
404
Peter Brawley
09/28/2018 11:08AM
Optimizer produces incorrect resultset  
567
J Barchan
09/27/2018 09:35AM
Manipulating queries with non-conforming data via MySQL Query Rewrite Plugin, triggers and stored procedures  
527
Edwin Desouza
09/07/2018 10:34AM
Where Clause Optimization  
687
Mohammed Yehia El Sayed Abdoh
08/31/2018 06:47AM
Re: Where Clause Optimization  
355
Peter Brawley
08/31/2018 01:55PM
Re: Where Clause Optimization  
366
Mohammed Yehia El Sayed Abdoh
08/31/2018 03:08PM
Re: Where Clause Optimization  
402
Øystein Grøvlen
09/03/2018 02:45AM
long execution time of all requests, drop base  
1,097
Уррик Зарик
06/10/2018 06:10AM
Re: long execution time of all requests, drop base  
502
Peter Brawley
06/10/2018 12:24PM
Re: long execution time of all requests, drop base  
522
Уррик Зарик
06/10/2018 12:40PM
Re: long execution time of all requests, drop base  
545
Peter Brawley
06/10/2018 02:24PM
Re: long execution time of all requests, drop base  
555
Urri Zar
06/11/2018 12:09AM
Re: long execution time of all requests, drop base  
446
Urri Zar
06/12/2018 10:25AM
Re: long execution time of all requests, drop base  
499
Peter Brawley
06/12/2018 10:27AM
Re: long execution time of all requests, drop base  
652
Urri Zar
06/12/2018 10:34AM
Re: long execution time of all requests, drop base  
612
Peter Brawley
06/12/2018 12:00PM
Create index for Join some table in MySQL  
662
Kenny Nguyen
05/20/2018 10:51PM
Re: Create index for Join some table in MySQL  
391
Øystein Grøvlen
05/30/2018 12:50AM
Determine time taken by commit statement after insert or update statement  
760
Priya Pawar
05/07/2018 02:01AM
Re: Determine time taken by commit statement after insert or update statement  
434
Jesús Uzcanga
05/07/2018 08:43AM
Re: Determine time taken by commit statement after insert or update statement  
366
Priya Pawar
05/08/2018 12:03AM
MySQL 8.0: One Giant Leap For SQL  
454
Edwin Desouza
04/25/2018 10:14AM
how to speed up query on a table with over 20million records?  
987
li zheng
03/25/2018 07:27AM
Re: how to speed up query on a table with over 20million records?  
483
li zheng
03/25/2018 08:38AM
Re: how to speed up query on a table with over 20million records?  
379
Peter Brawley
03/25/2018 01:59PM
Re: how to speed up query on a table with over 20million records?  
462
Peter Brawley
03/25/2018 03:04PM
Re: how to speed up query on a table with over 20million records?  
421
li zheng
03/25/2018 08:13PM
Re: how to speed up query on a table with over 20million records?  
449
Peter Brawley
03/25/2018 10:03PM
Re: how to speed up query on a table with over 20million records?  
375
li zheng
03/26/2018 02:41AM
optimize range query(using between, group by and order by)  
1,412
Özgen Erbakan
03/20/2018 02:34AM
Re: optimize range query(using between, group by and order by)  
612
Øystein Grøvlen
03/20/2018 03:52AM
Slow DELETE-Statement since update on 5.7  
1,367
engram GmbH
03/19/2018 07:51AM
Re: Slow DELETE-Statement since update on 5.7  
628
Peter Brawley
03/19/2018 11:40AM
Re: Slow DELETE-Statement since update on 5.7  
662
Øystein Grøvlen
03/19/2018 01:15PM
Re: Slow DELETE-Statement since update on 5.7  
591
engram GmbH
03/20/2018 02:09AM
Optimizer choosing wrong index  
519
Daniel Kasak
03/19/2018 05:48PM
MySQL 8.0: Histograms  
464
Edwin Desouza
03/01/2018 02:27PM
Indexing a small table increases the query cost  
960
Aram Mirzadeh
02/28/2018 04:52AM
Re: Indexing a small table increases the query cost  
396
Peter Brawley
02/28/2018 08:50AM
Re: Indexing a small table increases the query cost  
502
Aram Mirzadeh
02/28/2018 11:24AM
Re: Indexing a small table increases the query cost  
367
Aram Mirzadeh
02/28/2018 11:30AM
Re: Indexing a small table increases the query cost  
368
Peter Brawley
02/28/2018 12:58PM
Re: Indexing a small table increases the query cost  
439
Øystein Grøvlen
03/01/2018 03:15AM
MySQL: Ranking techniques  
549
Edwin Desouza
01/23/2018 11:23AM
MySQL 8.0: Row numbering, ranking: using Window Functions  
530
Edwin Desouza
12/22/2017 11:41PM
My query take along time  
825
Murawweh Daher
12/17/2017 07:18AM
Muranweh, please don't double-post  
326
Peter Brawley
12/17/2017 09:48AM
MySQL 8.0: Query Optimizer Takes Data Buffering into Account  
534
Edwin Desouza
12/07/2017 11:21AM
Compound index (pkey) not used when it should be  
843
Dan Parker
11/29/2017 01:39PM
Re: Compound index (pkey) not used when it should be  
471
Peter Brawley
11/29/2017 04:21PM
Re: Compound index (pkey) not used when it should be  
455
Dan Parker
11/29/2017 04:38PM
Re: Compound index (pkey) not used when it should be  
452
Peter Brawley
11/29/2017 05:16PM
Re: Compound index (pkey) not used when it should be  
461
Dan Parker
11/29/2017 05:25PM
Re: Compound index (pkey) not used when it should be  
460
Peter Brawley
11/29/2017 06:13PM
Re: Compound index (pkey) not used when it should be  
472
Dan Parker
11/29/2017 06:23PM
Re: Compound index (pkey) not used when it should be  
496
Peter Brawley
11/29/2017 07:46PM
Re: Compound index (pkey) not used when it should be  
466
Dan Parker
11/30/2017 10:31AM
Re: Compound index (pkey) not used when it should be  
432
Peter Brawley
12/01/2017 11:02AM
Re: Compound index (pkey) not used when it should be  
429
Dan Parker
12/01/2017 11:05AM
Re: Compound index (pkey) not used when it should be  
433
Peter Brawley
12/01/2017 11:19AM
Re: Compound index (pkey) not used when it should be  
446
Dan Parker
12/01/2017 11:26AM
Re: Compound index (pkey) not used when it should be  
453
Peter Brawley
12/01/2017 01:04PM
Re: Compound index (pkey) not used when it should be  
461
Dan Parker
12/01/2017 01:10PM
Re: Compound index (pkey) not used when it should be  
427
Peter Brawley
12/01/2017 05:01PM
Re: Compound index (pkey) not used when it should be  
437
Øystein Grøvlen
12/01/2017 10:10AM
Re: Compound index (pkey) not used when it should be  
467
Dan Parker
12/01/2017 10:36AM
Confirmation on possible parser bug  
685
Patrick Meredith
11/27/2017 10:47AM
Re: Confirmation on possible parser bug  
345
Peter Brawley
11/30/2017 11:20AM
Source code question related to sql_optimizer.cc line 8583  
755
Petru-Florin Mihancea
11/28/2017 04:20AM
Re: Source code question related to sql_optimizer.cc line 8583  
399
Øystein Grøvlen
11/28/2017 07:01AM
MySQL 8.0: Optimization to skip index dives with FORCE INDEX.  
653
Edwin Desouza
11/17/2017 09:50AM
Is Union Queries run in Parallel form or not.  
880
Azeem Haider
10/17/2017 11:40PM
Re: Is Union Queries run in Parallel form or not.  
467
Peter Brawley
10/18/2017 08:32AM
Re: Is Union Queries run in Parallel form or not.  
659
Azeem Haider
10/18/2017 10:43PM
Re: Is Union Queries run in Parallel form or not.  
468
Peter Brawley
10/18/2017 10:55PM
Re: Is Union Queries run in Parallel form or not.  
550
Øystein Grøvlen
10/19/2017 03:02AM
MySQL 8.0: Window Functions  
548
Edwin Desouza
10/04/2017 06:03PM
Grammer Rule for Parenthesis in Select Statement  
713
Sushant Choudhary
09/21/2017 12:47PM
Please don't duplicate posts  
419
Peter Brawley
09/21/2017 12:49PM
Help with explain on query  
629
Alex Titley
08/16/2017 09:09AM
Re: Help with explain on query  
348
Peter Brawley
08/16/2017 10:07AM
Optimizer Stablility  
622
Chris Reston
08/16/2017 12:56AM
Re: Optimizer Stablility  
401
Øystein Grøvlen
08/16/2017 02:19AM
Way to avoid fragmentation of MySQL tables  
605
Priya Pawar
07/30/2017 11:01AM
Re: Way to avoid fragmentation of MySQL tables  
514
Peter Brawley
07/30/2017 04:41PM
Re: Way to avoid fragmentation of MySQL tables  
387
Priya Pawar
07/30/2017 11:10PM
MySQL 8.0.2: Introducing Window Functions  
578
Edwin Desouza
07/18/2017 10:33AM
Can anyone help speed up this query?  
721
Search Team
06/21/2017 11:07AM
Re: Can anyone help speed up this query?  
442
Peter Brawley
06/21/2017 02:53PM
Re: Can anyone help speed up this query?  
455
Search Team
06/22/2017 09:15AM
Re: Can anyone help speed up this query?  
454
Peter Brawley
06/22/2017 12:54PM
Re: Can anyone help speed up this query?  
425
Search Team
06/23/2017 07:50AM
Re: Can anyone help speed up this query?  
371
Peter Brawley
06/23/2017 11:14AM
Re: Can anyone help speed up this query?  
442
Øystein Grøvlen
06/22/2017 01:18AM
Re: Can anyone help speed up this query?  
469
Search Team
06/22/2017 09:56AM
Re: Can anyone help speed up this query?  
450
Øystein Grøvlen
06/23/2017 12:53AM
Is there a better ANTLR grammar file for MySQL ?  
2,749
Bill Nicholson
05/28/2017 05:07PM
Re: Is there a better ANTLR grammar file for MySQL ?  
903
Edwin Desouza
05/29/2017 11:43PM
Re: Is there a better ANTLR grammar file for MySQL ?  
815
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  
920
Edwin Desouza
05/23/2017 11:01AM
MySQL Index Advisor for SQL Tuning  
3,417
Chaitanya Challa
05/10/2017 09:12PM
Re: MySQL Index Advisor for SQL Tuning  
2,074
Edwin Desouza
05/10/2017 10:57PM
Re: MySQL Index Advisor for SQL Tuning  
1,224
Chaitanya Challa
05/11/2017 08:08AM
MySQL 8.0: CTEs Recursive Query Throwdown  
1,317
Edwin Desouza
05/05/2017 06:14PM
MySQL 8.0: GROUPING function  
579
Edwin Desouza
05/02/2017 10:37AM
How to Analyze and Tune MySQL Queries for Better Performance  
585
Edwin Desouza
04/27/2017 11:32AM
MySQL 8.0: Optimizer: What's New  
659
Edwin Desouza
04/27/2017 11:31AM
MySQL 8.0 Optimizer Guide  
719
Edwin Desouza
04/27/2017 11:30AM
MySQL 8.0.1: Using SKIP LOCKED and NOWAIT to handle hot rows  
693
Edwin Desouza
04/12/2017 11:57AM
MySQL 8.0: Improved performance with CTE  
636
Edwin Desouza
04/12/2017 11:57AM
MySQL 5.7: What to Do When the Optimizer Overestimates the Condition Filtering Effect  
606
Edwin Desouza
03/24/2017 11:30AM
prepare don't work for optimize statement  
811
Long WU
03/22/2017 12:30AM
Re: prepare don't work for optimize statement  
401
Øystein Grøvlen
03/22/2017 01:34AM
MySQL 5.7: Improved JOIN Order by Taking Condition Filter Effect into Account  
707
Edwin Desouza
03/17/2017 02:49PM
Improve search when using IN() ORDER BY PRIMARY and LIMIT  
1,089
jon sans
02/11/2017 07:17AM
Re: Improve search when using IN() ORDER BY PRIMARY and LIMIT  
373
jon sans
02/11/2017 07:29AM
Re: Improve search when using IN() ORDER BY PRIMARY and LIMIT  
477
Øystein Grøvlen
02/13/2017 05:58AM
MySQL Performance Tuning: Optimizer Hints  
630
Edwin Desouza
02/04/2017 09:09PM
Hiw to fast delete rows from table in relation?  
861
Andrzej Borucki
01/22/2017 02:21AM
Re: Hiw to fast delete rows from table in relation?  
466
Andrzej Borucki
01/22/2017 03:39AM
Re: Hiw to fast delete rows from table in relation?  
451
Andrzej Borucki
01/22/2017 04:03AM
Query not always using indexes  
1,998
K DBA
01/06/2017 05:48AM
Re: Query not always using indexes  
664
Peter Brawley
01/06/2017 12:28PM
Re: Query not always using indexes  
754
K DBA
01/09/2017 05:18AM
Re: Query not always using indexes  
655
Øystein Grøvlen
01/09/2017 02:30AM
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.