MySQL :: MySQL Forums :: Optimizer & Parser

New Topic

Pages:

« 1 2 3 4 5

...

19 »

Subject

Views

Written By

Posted

Query optimization and indexing - Help needed

902

Pandit P

06/13/2019 06:41AM

Re: Query optimization and indexing - Help needed

431

Peter Brawley

06/13/2019 12:55PM

Re: Query optimization and indexing - Help needed

417

Pandit P

06/14/2019 12:01AM

Re: Query optimization and indexing - Help needed

444

Peter Brawley

06/14/2019 07:51AM

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

914

Ted Johnson

05/29/2019 02:12PM

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

442

Peter Brawley

05/29/2019 03:00PM

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

421

Ted Johnson

05/29/2019 04:41PM

CHECK constraints in MySQL

792

Edwin Desouza

05/14/2019 09:37AM

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

765

Edwin Desouza

04/10/2019 09:14AM

Comparing two columns on big table

1,567

Krzysztof Wróblewski

03/21/2019 03:24PM

Re: Comparing two columns on big table

589

Peter Brawley

03/21/2019 04:24PM

help with this query

767

sha fendi

03/16/2019 09:17PM

Re: help with this query

440

Peter Brawley

03/17/2019 11:04AM

MySQL Functional Indexes

640

Edwin Desouza

03/14/2019 09:49AM

MySQL 8.0: Query analytics [CTEs, Window Functions]

673

Edwin Desouza

03/09/2019 11:04PM

MySQL 8.0: Improvements to ROLLUP

651

Edwin Desouza

03/05/2019 11:53AM

MySQL 8.0: Window Functions for JSON

637

Edwin Desouza

02/21/2019 11:08AM

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

795

aaron chan

02/19/2019 09:00PM

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

400

Peter Brawley

02/20/2019 10:47AM

MySQL 8.0: New Index Features

706

Edwin Desouza

02/08/2019 11:18AM

MySQL 8.0: support for LATERAL derived tables

715

Edwin Desouza

01/31/2019 11:07AM

MySQL 8.0: Keywords

1,120

Edwin Desouza

01/10/2019 09:22PM

I Need Help To Write Queries

434

Mostafa Baghi

12/17/2018 04:40AM

MySQL 8.0: Window Functions with Unusual Boundaries

739

Edwin Desouza

11/08/2018 02:42PM

More SQL in MySQL 8.0

1,011

Edwin Desouza

11/06/2018 07:28PM

MySQL 8.0: What Is New in Optimizer and Executor?

695

Edwin Desouza

11/01/2018 11:10AM

Optimizer Improvements in MySQL 8.0

715

Edwin Desouza

10/31/2018 09:31PM

Indexes are not working after restoring dump

1,278

Amit K

09/27/2018 11:25AM

Re: Indexes are not working after restoring dump

721

Amit K

09/27/2018 01:39PM

Re: Indexes are not working after restoring dump

597

Amit K

09/27/2018 01:45PM

Re: Indexes are not working after restoring dump

644

Øystein Grøvlen

09/28/2018 12:21AM

Re: Indexes are not working after restoring dump

626

Peter Brawley

09/27/2018 07:14PM

Re: Indexes are not working after restoring dump

559

Amit K

09/27/2018 08:31PM

Re: Indexes are not working after restoring dump

578

Peter Brawley

09/28/2018 11:08AM

Optimizer produces incorrect resultset

753

J Barchan

09/27/2018 09:35AM

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

664

Edwin Desouza

09/07/2018 10:34AM

Where Clause Optimization

831

Mohammed Yehia El Sayed Abdoh

08/31/2018 06:47AM

Re: Where Clause Optimization

435

Peter Brawley

08/31/2018 01:55PM

Re: Where Clause Optimization

450

Mohammed Yehia El Sayed Abdoh

08/31/2018 03:08PM

Re: Where Clause Optimization

497

Øystein Grøvlen

09/03/2018 02:45AM

long execution time of all requests, drop base

1,329

Уррик Зарик

06/10/2018 06:10AM

Re: long execution time of all requests, drop base

631

Peter Brawley

06/10/2018 12:24PM

Re: long execution time of all requests, drop base

636

Уррик Зарик

06/10/2018 12:40PM

Re: long execution time of all requests, drop base

662

Peter Brawley

06/10/2018 02:24PM

Re: long execution time of all requests, drop base

668

Urri Zar

06/11/2018 12:09AM

Re: long execution time of all requests, drop base

526

Urri Zar

06/12/2018 10:25AM

Re: long execution time of all requests, drop base

608

Peter Brawley

06/12/2018 10:27AM

Re: long execution time of all requests, drop base

828

Urri Zar

06/12/2018 10:34AM

Re: long execution time of all requests, drop base

750

Peter Brawley

06/12/2018 12:00PM

Create index for Join some table in MySQL

858

Kenny Nguyen

05/20/2018 10:51PM

Re: Create index for Join some table in MySQL

454

Øystein Grøvlen

05/30/2018 12:50AM

Determine time taken by commit statement after insert or update statement

906

Priya Pawar

05/07/2018 02:01AM

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

617

Jesús Uzcanga

05/07/2018 08:43AM

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

456

Priya Pawar

05/08/2018 12:03AM

MySQL 8.0: One Giant Leap For SQL

565

Edwin Desouza

04/25/2018 10:14AM

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

1,177

li zheng

03/25/2018 07:27AM

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

607

li zheng

03/25/2018 08:38AM

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

457

Peter Brawley

03/25/2018 01:59PM

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

568

Peter Brawley

03/25/2018 03:04PM

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

539

li zheng

03/25/2018 08:13PM

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

562

Peter Brawley

03/25/2018 10:03PM

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

445

li zheng

03/26/2018 02:41AM

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

1,652

Özgen Erbakan

03/20/2018 02:34AM

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

766

Øystein Grøvlen

03/20/2018 03:52AM

Slow DELETE-Statement since update on 5.7

1,770

engram GmbH

03/19/2018 07:51AM

Re: Slow DELETE-Statement since update on 5.7

762

Peter Brawley

03/19/2018 11:40AM

Re: Slow DELETE-Statement since update on 5.7

855

Øystein Grøvlen

03/19/2018 01:15PM

Re: Slow DELETE-Statement since update on 5.7

779

engram GmbH

03/20/2018 02:09AM

Optimizer choosing wrong index

651

Daniel Kasak

03/19/2018 05:48PM

MySQL 8.0: Histograms

553

Edwin Desouza

03/01/2018 02:27PM

Indexing a small table increases the query cost

1,188

Aram Mirzadeh

02/28/2018 04:52AM

Re: Indexing a small table increases the query cost

478

Peter Brawley

02/28/2018 08:50AM

Re: Indexing a small table increases the query cost

596

Aram Mirzadeh

02/28/2018 11:24AM

Re: Indexing a small table increases the query cost

444

Aram Mirzadeh

02/28/2018 11:30AM

Re: Indexing a small table increases the query cost

445

Peter Brawley

02/28/2018 12:58PM

Re: Indexing a small table increases the query cost

616

Øystein Grøvlen

03/01/2018 03:15AM

MySQL: Ranking techniques

686

Edwin Desouza

01/23/2018 11:23AM

MySQL 8.0: Row numbering, ranking: using Window Functions

646

Edwin Desouza

12/22/2017 11:41PM

My query take along time

1,011

Murawweh Daher

12/17/2017 07:18AM

Muranweh, please don't double-post

395

Peter Brawley

12/17/2017 09:48AM

MySQL 8.0: Query Optimizer Takes Data Buffering into Account

667

Edwin Desouza

12/07/2017 11:21AM

Compound index (pkey) not used when it should be

1,079

Dan Parker

11/29/2017 01:39PM

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

569

Peter Brawley

11/29/2017 04:21PM

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

585

Dan Parker

11/29/2017 04:38PM

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

565

Peter Brawley

11/29/2017 05:16PM

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

624

Dan Parker

11/29/2017 05:25PM

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

567

Peter Brawley

11/29/2017 06:13PM

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

616

Dan Parker

11/29/2017 06:23PM

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

624

Peter Brawley

11/29/2017 07:46PM

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

599

Dan Parker

11/30/2017 10:31AM

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

547

Peter Brawley

12/01/2017 11:02AM

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

543

Dan Parker

12/01/2017 11:05AM

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

582

Peter Brawley

12/01/2017 11:19AM

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

609

Dan Parker

12/01/2017 11:26AM

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

569

Peter Brawley

12/01/2017 01:04PM

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

587

Dan Parker

12/01/2017 01:10PM

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

545

Peter Brawley

12/01/2017 05:01PM

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

565

Øystein Grøvlen

12/01/2017 10:10AM

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

601

Dan Parker

12/01/2017 10:36AM

Confirmation on possible parser bug

827

Patrick Meredith

11/27/2017 10:47AM

Re: Confirmation on possible parser bug

417

Peter Brawley

11/30/2017 11:20AM

Source code question related to sql_optimizer.cc line 8583

947

Petru-Florin Mihancea

11/28/2017 04:20AM

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

498

Øystein Grøvlen

11/28/2017 07:01AM

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

773

Edwin Desouza

11/17/2017 09:50AM

Is Union Queries run in Parallel form or not.

1,097

Azeem Haider

10/17/2017 11:40PM

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

610

Peter Brawley

10/18/2017 08:32AM

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

965

Azeem Haider

10/18/2017 10:43PM

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

581

Peter Brawley

10/18/2017 10:55PM

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

717

Øystein Grøvlen

10/19/2017 03:02AM

MySQL 8.0: Window Functions

703

Edwin Desouza

10/04/2017 06:03PM

Grammer Rule for Parenthesis in Select Statement

864

Sushant Choudhary

09/21/2017 12:47PM

Please don't duplicate posts

505

Peter Brawley

09/21/2017 12:49PM

Help with explain on query

749

Alex Titley

08/16/2017 09:09AM

Re: Help with explain on query

415

Peter Brawley

08/16/2017 10:07AM

Optimizer Stablility

790

Chris Reston

08/16/2017 12:56AM

Re: Optimizer Stablility

490

Øystein Grøvlen

08/16/2017 02:19AM

Way to avoid fragmentation of MySQL tables

752

Priya Pawar

07/30/2017 11:01AM

Re: Way to avoid fragmentation of MySQL tables

637

Peter Brawley

07/30/2017 04:41PM

Re: Way to avoid fragmentation of MySQL tables

477

Priya Pawar

07/30/2017 11:10PM

MySQL 8.0.2: Introducing Window Functions

738

Edwin Desouza

07/18/2017 10:33AM

Can anyone help speed up this query?

900

Search Team

06/21/2017 11:07AM