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

1,580

Pandit P

06/13/2019 06:41AM

Re: Query optimization and indexing - Help needed

682

Peter Brawley

06/13/2019 12:55PM

Re: Query optimization and indexing - Help needed

699

Pandit P

06/14/2019 12:01AM

Re: Query optimization and indexing - Help needed

742

Peter Brawley

06/14/2019 07:51AM

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

2,058

Ted Johnson

05/29/2019 02:12PM

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

750

Peter Brawley

05/29/2019 03:00PM

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

732

Ted Johnson

05/29/2019 04:41PM

CHECK constraints in MySQL

1,273

Edwin Desouza

05/14/2019 09:37AM

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

1,307

Edwin Desouza

04/10/2019 09:14AM

Comparing two columns on big table

2,450

Krzysztof Wróblewski

03/21/2019 03:24PM

Re: Comparing two columns on big table

892

Peter Brawley

03/21/2019 04:24PM

help with this query

1,383

sha fendi

03/16/2019 09:17PM

Re: help with this query

781

Peter Brawley

03/17/2019 11:04AM

MySQL Functional Indexes

1,096

Edwin Desouza

03/14/2019 09:49AM

MySQL 8.0: Query analytics [CTEs, Window Functions]

1,134

Edwin Desouza

03/09/2019 11:04PM

MySQL 8.0: Improvements to ROLLUP

1,161

Edwin Desouza

03/05/2019 11:53AM

MySQL 8.0: Window Functions for JSON

1,033

Edwin Desouza

02/21/2019 11:08AM

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

1,472

aaron chan

02/19/2019 09:00PM

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

686

Peter Brawley

02/20/2019 10:47AM

MySQL 8.0: New Index Features

1,185

Edwin Desouza

02/08/2019 11:18AM

MySQL 8.0: support for LATERAL derived tables

1,268

Edwin Desouza

01/31/2019 11:07AM

MySQL 8.0: Keywords

1,568

Edwin Desouza

01/10/2019 09:22PM

I Need Help To Write Queries

905

Mostafa Baghi

12/17/2018 04:40AM

MySQL 8.0: Window Functions with Unusual Boundaries

1,202

Edwin Desouza

11/08/2018 02:42PM

More SQL in MySQL 8.0

1,587

Edwin Desouza

11/06/2018 07:28PM

MySQL 8.0: What Is New in Optimizer and Executor?

1,181

Edwin Desouza

11/01/2018 11:10AM

Optimizer Improvements in MySQL 8.0

1,196

Edwin Desouza

10/31/2018 09:31PM

Indexes are not working after restoring dump

2,065

Amit K

09/27/2018 11:25AM

Re: Indexes are not working after restoring dump

1,162

Amit K

09/27/2018 01:39PM

Re: Indexes are not working after restoring dump

913

Amit K

09/27/2018 01:45PM

Re: Indexes are not working after restoring dump

1,026

Øystein Grøvlen

09/28/2018 12:21AM

Re: Indexes are not working after restoring dump

959

Peter Brawley

09/27/2018 07:14PM

Re: Indexes are not working after restoring dump

869

Amit K

09/27/2018 08:31PM

Re: Indexes are not working after restoring dump

869

Peter Brawley

09/28/2018 11:08AM

Optimizer produces incorrect resultset

1,264

J Barchan

09/27/2018 09:35AM

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

1,096

Edwin Desouza

09/07/2018 10:34AM

Where Clause Optimization

1,356

Mohammed Yehia El Sayed Abdoh

08/31/2018 06:47AM

Re: Where Clause Optimization

691

Peter Brawley

08/31/2018 01:55PM

Re: Where Clause Optimization

770

Mohammed Yehia El Sayed Abdoh

08/31/2018 03:08PM

Re: Where Clause Optimization

773

Øystein Grøvlen

09/03/2018 02:45AM

long execution time of all requests, drop base

1,965

Уррик Зарик

06/10/2018 06:10AM

Re: long execution time of all requests, drop base

930

Peter Brawley

06/10/2018 12:24PM

Re: long execution time of all requests, drop base

930

Уррик Зарик

06/10/2018 12:40PM

Re: long execution time of all requests, drop base

922

Peter Brawley

06/10/2018 02:24PM

Re: long execution time of all requests, drop base

977

Urri Zar

06/11/2018 12:09AM

Re: long execution time of all requests, drop base

780

Urri Zar

06/12/2018 10:25AM

Re: long execution time of all requests, drop base

944

Peter Brawley

06/12/2018 10:27AM

Re: long execution time of all requests, drop base

1,331

Urri Zar

06/12/2018 10:34AM

Re: long execution time of all requests, drop base

1,040

Peter Brawley

06/12/2018 12:00PM

Create index for Join some table in MySQL

1,479

Kenny Nguyen

05/20/2018 10:51PM

Re: Create index for Join some table in MySQL

705

Øystein Grøvlen

05/30/2018 12:50AM

Determine time taken by commit statement after insert or update statement

1,435

Priya Pawar

05/07/2018 02:01AM

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

925

Jesús Uzcanga

05/07/2018 08:43AM

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

696

Priya Pawar

05/08/2018 12:03AM

MySQL 8.0: One Giant Leap For SQL

1,043

Edwin Desouza

04/25/2018 10:14AM

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

1,879

li zheng

03/25/2018 07:27AM

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

972

li zheng

03/25/2018 08:38AM

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

831

Peter Brawley

03/25/2018 01:59PM

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

927

Peter Brawley

03/25/2018 03:04PM

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

928

li zheng

03/25/2018 08:13PM

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

980

Peter Brawley

03/25/2018 10:03PM

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

814

li zheng

03/26/2018 02:41AM

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

2,303

Özgen Erbakan

03/20/2018 02:34AM

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

982

Øystein Grøvlen

03/20/2018 03:52AM

Slow DELETE-Statement since update on 5.7

2,548

engram GmbH

03/19/2018 07:51AM

Re: Slow DELETE-Statement since update on 5.7

1,029

Peter Brawley

03/19/2018 11:40AM

Re: Slow DELETE-Statement since update on 5.7

1,215

Øystein Grøvlen

03/19/2018 01:15PM

Re: Slow DELETE-Statement since update on 5.7

1,220

engram GmbH

03/20/2018 02:09AM

Optimizer choosing wrong index

1,192

Daniel Kasak

03/19/2018 05:48PM

MySQL 8.0: Histograms

1,048

Edwin Desouza

03/01/2018 02:27PM

Indexing a small table increases the query cost

1,756

Aram Mirzadeh

02/28/2018 04:52AM

Re: Indexing a small table increases the query cost

730

Peter Brawley

02/28/2018 08:50AM

Re: Indexing a small table increases the query cost

896

Aram Mirzadeh

02/28/2018 11:24AM

Re: Indexing a small table increases the query cost

748

Aram Mirzadeh

02/28/2018 11:30AM

Re: Indexing a small table increases the query cost

717

Peter Brawley

02/28/2018 12:58PM

Re: Indexing a small table increases the query cost

982

Øystein Grøvlen

03/01/2018 03:15AM

MySQL: Ranking techniques

1,164

Edwin Desouza

01/23/2018 11:23AM

MySQL 8.0: Row numbering, ranking: using Window Functions

1,145

Edwin Desouza

12/22/2017 11:41PM

My query take along time

1,535

Murawweh Daher

12/17/2017 07:18AM

Muranweh, please don't double-post

639

Peter Brawley

12/17/2017 09:48AM

MySQL 8.0: Query Optimizer Takes Data Buffering into Account

1,087

Edwin Desouza

12/07/2017 11:21AM

Compound index (pkey) not used when it should be

1,702

Dan Parker

11/29/2017 01:39PM

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

857

Peter Brawley

11/29/2017 04:21PM

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

892

Dan Parker

11/29/2017 04:38PM

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

845

Peter Brawley

11/29/2017 05:16PM

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

939

Dan Parker

11/29/2017 05:25PM

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

827

Peter Brawley

11/29/2017 06:13PM

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

912

Dan Parker

11/29/2017 06:23PM

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

1,003

Peter Brawley

11/29/2017 07:46PM

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

1,013

Dan Parker

11/30/2017 10:31AM

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

878

Peter Brawley

12/01/2017 11:02AM

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

858

Dan Parker

12/01/2017 11:05AM

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

943

Peter Brawley

12/01/2017 11:19AM

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

971

Dan Parker

12/01/2017 11:26AM

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

860

Peter Brawley

12/01/2017 01:04PM

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

920

Dan Parker

12/01/2017 01:10PM

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

891

Peter Brawley

12/01/2017 05:01PM

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

941

Øystein Grøvlen

12/01/2017 10:10AM

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

947

Dan Parker

12/01/2017 10:36AM

Confirmation on possible parser bug

1,285

Patrick Meredith

11/27/2017 10:47AM

Re: Confirmation on possible parser bug

664

Peter Brawley

11/30/2017 11:20AM

Source code question related to sql_optimizer.cc line 8583

1,490

Petru-Florin Mihancea

11/28/2017 04:20AM

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

743

Øystein Grøvlen

11/28/2017 07:01AM

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

1,228

Edwin Desouza

11/17/2017 09:50AM

Is Union Queries run in Parallel form or not.

1,875

Azeem Haider

10/17/2017 11:40PM

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

992

Peter Brawley

10/18/2017 08:32AM

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

1,335

Azeem Haider

10/18/2017 10:43PM

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

893

Peter Brawley

10/18/2017 10:55PM

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

1,131

Øystein Grøvlen

10/19/2017 03:02AM

MySQL 8.0: Window Functions

1,164

Edwin Desouza

10/04/2017 06:03PM

Grammer Rule for Parenthesis in Select Statement

1,372

Sushant Choudhary

09/21/2017 12:47PM

Please don't duplicate posts

762

Peter Brawley

09/21/2017 12:49PM

Help with explain on query

1,272

Alex Titley

08/16/2017 09:09AM

Re: Help with explain on query

695

Peter Brawley

08/16/2017 10:07AM

Optimizer Stablility

1,271

Chris Reston

08/16/2017 12:56AM

Re: Optimizer Stablility

772

Øystein Grøvlen

08/16/2017 02:19AM

Way to avoid fragmentation of MySQL tables

1,221

Priya Pawar

07/30/2017 11:01AM

Re: Way to avoid fragmentation of MySQL tables

935

Peter Brawley

07/30/2017 04:41PM

Re: Way to avoid fragmentation of MySQL tables

722

Priya Pawar

07/30/2017 11:10PM

MySQL 8.0.2: Introducing Window Functions

1,220

Edwin Desouza

07/18/2017 10:33AM

Can anyone help speed up this query?

1,417

Search Team

06/21/2017 11:07AM