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,250

Pandit P

06/13/2019 06:41AM

Re: Query optimization and indexing - Help needed

573

Peter Brawley

06/13/2019 12:55PM

Re: Query optimization and indexing - Help needed

575

Pandit P

06/14/2019 12:01AM

Re: Query optimization and indexing - Help needed

625

Peter Brawley

06/14/2019 07:51AM

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

1,243

Ted Johnson

05/29/2019 02:12PM

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

614

Peter Brawley

05/29/2019 03:00PM

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

621

Ted Johnson

05/29/2019 04:41PM

CHECK constraints in MySQL

1,020

Edwin Desouza

05/14/2019 09:37AM

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

1,052

Edwin Desouza

04/10/2019 09:14AM

Comparing two columns on big table

2,098

Krzysztof Wróblewski

03/21/2019 03:24PM

Re: Comparing two columns on big table

765

Peter Brawley

03/21/2019 04:24PM

help with this query

1,117

sha fendi

03/16/2019 09:17PM

Re: help with this query

645

Peter Brawley

03/17/2019 11:04AM

MySQL Functional Indexes

869

Edwin Desouza

03/14/2019 09:49AM

MySQL 8.0: Query analytics [CTEs, Window Functions]

898

Edwin Desouza

03/09/2019 11:04PM

MySQL 8.0: Improvements to ROLLUP

914

Edwin Desouza

03/05/2019 11:53AM

MySQL 8.0: Window Functions for JSON

817

Edwin Desouza

02/21/2019 11:08AM

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

1,135

aaron chan

02/19/2019 09:00PM

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

562

Peter Brawley

02/20/2019 10:47AM

MySQL 8.0: New Index Features

947

Edwin Desouza

02/08/2019 11:18AM

MySQL 8.0: support for LATERAL derived tables

985

Edwin Desouza

01/31/2019 11:07AM

MySQL 8.0: Keywords

1,348

Edwin Desouza

01/10/2019 09:22PM

I Need Help To Write Queries

634

Mostafa Baghi

12/17/2018 04:40AM

MySQL 8.0: Window Functions with Unusual Boundaries

964

Edwin Desouza

11/08/2018 02:42PM

More SQL in MySQL 8.0

1,293

Edwin Desouza

11/06/2018 07:28PM

MySQL 8.0: What Is New in Optimizer and Executor?

937

Edwin Desouza

11/01/2018 11:10AM

Optimizer Improvements in MySQL 8.0

966

Edwin Desouza

10/31/2018 09:31PM

Indexes are not working after restoring dump

1,770

Amit K

09/27/2018 11:25AM

Re: Indexes are not working after restoring dump

999

Amit K

09/27/2018 01:39PM

Re: Indexes are not working after restoring dump

795

Amit K

09/27/2018 01:45PM

Re: Indexes are not working after restoring dump

880

Øystein Grøvlen

09/28/2018 12:21AM

Re: Indexes are not working after restoring dump

799

Peter Brawley

09/27/2018 07:14PM

Re: Indexes are not working after restoring dump

753

Amit K

09/27/2018 08:31PM

Re: Indexes are not working after restoring dump

743

Peter Brawley

09/28/2018 11:08AM

Optimizer produces incorrect resultset

1,005

J Barchan

09/27/2018 09:35AM

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

885

Edwin Desouza

09/07/2018 10:34AM

Where Clause Optimization

1,122

Mohammed Yehia El Sayed Abdoh

08/31/2018 06:47AM

Re: Where Clause Optimization

576

Peter Brawley

08/31/2018 01:55PM

Re: Where Clause Optimization

618

Mohammed Yehia El Sayed Abdoh

08/31/2018 03:08PM

Re: Where Clause Optimization

667

Øystein Grøvlen

09/03/2018 02:45AM

long execution time of all requests, drop base

1,601

Уррик Зарик

06/10/2018 06:10AM

Re: long execution time of all requests, drop base

829

Peter Brawley

06/10/2018 12:24PM

Re: long execution time of all requests, drop base

796

Уррик Зарик

06/10/2018 12:40PM

Re: long execution time of all requests, drop base

804

Peter Brawley

06/10/2018 02:24PM

Re: long execution time of all requests, drop base

833

Urri Zar

06/11/2018 12:09AM

Re: long execution time of all requests, drop base

650

Urri Zar

06/12/2018 10:25AM

Re: long execution time of all requests, drop base

811

Peter Brawley

06/12/2018 10:27AM

Re: long execution time of all requests, drop base

1,092

Urri Zar

06/12/2018 10:34AM

Re: long execution time of all requests, drop base

904

Peter Brawley

06/12/2018 12:00PM

Create index for Join some table in MySQL

1,175

Kenny Nguyen

05/20/2018 10:51PM

Re: Create index for Join some table in MySQL

590

Øystein Grøvlen

05/30/2018 12:50AM

Determine time taken by commit statement after insert or update statement

1,175

Priya Pawar

05/07/2018 02:01AM

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

793

Jesús Uzcanga

05/07/2018 08:43AM

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

590

Priya Pawar

05/08/2018 12:03AM

MySQL 8.0: One Giant Leap For SQL

840

Edwin Desouza

04/25/2018 10:14AM

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

1,568

li zheng

03/25/2018 07:27AM

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

773

li zheng

03/25/2018 08:38AM

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

647

Peter Brawley

03/25/2018 01:59PM

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

782

Peter Brawley

03/25/2018 03:04PM

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

716

li zheng

03/25/2018 08:13PM

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

787

Peter Brawley

03/25/2018 10:03PM

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

632

li zheng

03/26/2018 02:41AM

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

2,017

Özgen Erbakan

03/20/2018 02:34AM

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

887

Øystein Grøvlen

03/20/2018 03:52AM

Slow DELETE-Statement since update on 5.7

2,232

engram GmbH

03/19/2018 07:51AM

Re: Slow DELETE-Statement since update on 5.7

907

Peter Brawley

03/19/2018 11:40AM

Re: Slow DELETE-Statement since update on 5.7

1,074

Øystein Grøvlen

03/19/2018 01:15PM

Re: Slow DELETE-Statement since update on 5.7

1,014

engram GmbH

03/20/2018 02:09AM

Optimizer choosing wrong index

902

Daniel Kasak

03/19/2018 05:48PM

MySQL 8.0: Histograms

803

Edwin Desouza

03/01/2018 02:27PM

Indexing a small table increases the query cost

1,467

Aram Mirzadeh

02/28/2018 04:52AM

Re: Indexing a small table increases the query cost

618

Peter Brawley

02/28/2018 08:50AM

Re: Indexing a small table increases the query cost

743

Aram Mirzadeh

02/28/2018 11:24AM

Re: Indexing a small table increases the query cost

612

Aram Mirzadeh

02/28/2018 11:30AM

Re: Indexing a small table increases the query cost

563

Peter Brawley

02/28/2018 12:58PM

Re: Indexing a small table increases the query cost

830

Øystein Grøvlen

03/01/2018 03:15AM

MySQL: Ranking techniques

907

Edwin Desouza

01/23/2018 11:23AM

MySQL 8.0: Row numbering, ranking: using Window Functions

904

Edwin Desouza

12/22/2017 11:41PM

My query take along time

1,296

Murawweh Daher

12/17/2017 07:18AM

Muranweh, please don't double-post

528

Peter Brawley

12/17/2017 09:48AM

MySQL 8.0: Query Optimizer Takes Data Buffering into Account

884

Edwin Desouza

12/07/2017 11:21AM

Compound index (pkey) not used when it should be

1,406

Dan Parker

11/29/2017 01:39PM

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

707

Peter Brawley

11/29/2017 04:21PM

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

748

Dan Parker

11/29/2017 04:38PM

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

704

Peter Brawley

11/29/2017 05:16PM

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

801

Dan Parker

11/29/2017 05:25PM

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

716

Peter Brawley

11/29/2017 06:13PM

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

784

Dan Parker

11/29/2017 06:23PM

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

845

Peter Brawley

11/29/2017 07:46PM

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

831

Dan Parker

11/30/2017 10:31AM

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

717

Peter Brawley

12/01/2017 11:02AM

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

712

Dan Parker

12/01/2017 11:05AM

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

780

Peter Brawley

12/01/2017 11:19AM

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

824

Dan Parker

12/01/2017 11:26AM

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

715

Peter Brawley

12/01/2017 01:04PM

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

762

Dan Parker

12/01/2017 01:10PM

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

753

Peter Brawley

12/01/2017 05:01PM

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

802

Øystein Grøvlen

12/01/2017 10:10AM

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

792

Dan Parker

12/01/2017 10:36AM

Confirmation on possible parser bug

1,049

Patrick Meredith

11/27/2017 10:47AM

Re: Confirmation on possible parser bug

556

Peter Brawley

11/30/2017 11:20AM

Source code question related to sql_optimizer.cc line 8583

1,200

Petru-Florin Mihancea

11/28/2017 04:20AM

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

624

Øystein Grøvlen

11/28/2017 07:01AM

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

1,011

Edwin Desouza

11/17/2017 09:50AM

Is Union Queries run in Parallel form or not.

1,467

Azeem Haider

10/17/2017 11:40PM

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

869

Peter Brawley

10/18/2017 08:32AM

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

1,200

Azeem Haider

10/18/2017 10:43PM

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

781

Peter Brawley

10/18/2017 10:55PM

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

949

Øystein Grøvlen

10/19/2017 03:02AM

MySQL 8.0: Window Functions

946

Edwin Desouza

10/04/2017 06:03PM

Grammer Rule for Parenthesis in Select Statement

1,103

Sushant Choudhary

09/21/2017 12:47PM

Please don't duplicate posts

623

Peter Brawley

09/21/2017 12:49PM

Help with explain on query

1,031

Alex Titley

08/16/2017 09:09AM

Re: Help with explain on query

544

Peter Brawley

08/16/2017 10:07AM

Optimizer Stablility

1,042

Chris Reston

08/16/2017 12:56AM

Re: Optimizer Stablility

634

Øystein Grøvlen

08/16/2017 02:19AM

Way to avoid fragmentation of MySQL tables

1,007

Priya Pawar

07/30/2017 11:01AM

Re: Way to avoid fragmentation of MySQL tables

826

Peter Brawley

07/30/2017 04:41PM

Re: Way to avoid fragmentation of MySQL tables

613

Priya Pawar

07/30/2017 11:10PM

MySQL 8.0.2: Introducing Window Functions

986

Edwin Desouza

07/18/2017 10:33AM

Can anyone help speed up this query?

1,194

Search Team

06/21/2017 11:07AM