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

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

627

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

616

Peter Brawley

05/29/2019 03:00PM

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

622

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

Edwin Desouza

04/10/2019 09:14AM

Comparing two columns on big table

2,102

Krzysztof Wróblewski

03/21/2019 03:24PM

Re: Comparing two columns on big table

766

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

871

Edwin Desouza

03/14/2019 09:49AM

MySQL 8.0: Query analytics [CTEs, Window Functions]

900

Edwin Desouza

03/09/2019 11:04PM

MySQL 8.0: Improvements to ROLLUP

915

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

aaron chan

02/19/2019 09:00PM

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

564

Peter Brawley

02/20/2019 10:47AM

MySQL 8.0: New Index Features

950

Edwin Desouza

02/08/2019 11:18AM

MySQL 8.0: support for LATERAL derived tables

990

Edwin Desouza

01/31/2019 11:07AM

MySQL 8.0: Keywords

1,350

Edwin Desouza

01/10/2019 09:22PM

I Need Help To Write Queries

635

Mostafa Baghi

12/17/2018 04:40AM

MySQL 8.0: Window Functions with Unusual Boundaries

965

Edwin Desouza

11/08/2018 02:42PM

More SQL in MySQL 8.0

1,297

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

969

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

1,001

Amit K

09/27/2018 01:39PM

Re: Indexes are not working after restoring dump

796

Amit K

09/27/2018 01:45PM

Re: Indexes are not working after restoring dump

883

Ø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

754

Amit K

09/27/2018 08:31PM

Re: Indexes are not working after restoring dump

744

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

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

620

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

Уррик Зарик

06/10/2018 06:10AM

Re: long execution time of all requests, drop base

830

Peter Brawley

06/10/2018 12:24PM

Re: long execution time of all requests, drop base

797

Уррик Зарик

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

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

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

794

Jesús Uzcanga

05/07/2018 08:43AM

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

591

Priya Pawar

05/08/2018 12:03AM

MySQL 8.0: One Giant Leap For SQL

842

Edwin Desouza

04/25/2018 10:14AM

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

1,569

li zheng

03/25/2018 07:27AM

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

783

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?

783

Peter Brawley

03/25/2018 03:04PM

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

720

li zheng

03/25/2018 08:13PM

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

788

Peter Brawley

03/25/2018 10:03PM

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

634

li zheng

03/26/2018 02:41AM

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

2,019

Ö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,233

engram GmbH

03/19/2018 07:51AM

Re: Slow DELETE-Statement since update on 5.7

909

Peter Brawley

03/19/2018 11:40AM

Re: Slow DELETE-Statement since update on 5.7

1,077

Øystein Grøvlen

03/19/2018 01:15PM

Re: Slow DELETE-Statement since update on 5.7

1,016

engram GmbH

03/20/2018 02:09AM

Optimizer choosing wrong index

904

Daniel Kasak

03/19/2018 05:48PM

MySQL 8.0: Histograms

804

Edwin Desouza

03/01/2018 02:27PM

Indexing a small table increases the query cost

1,469

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

744

Aram Mirzadeh

02/28/2018 11:24AM

Re: Indexing a small table increases the query cost

613

Aram Mirzadeh

02/28/2018 11:30AM

Re: Indexing a small table increases the query cost

564

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

908

Edwin Desouza

01/23/2018 11:23AM

MySQL 8.0: Row numbering, ranking: using Window Functions

908

Edwin Desouza

12/22/2017 11:41PM

My query take along time

1,300

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

886

Edwin Desouza

12/07/2017 11:21AM

Compound index (pkey) not used when it should be

1,409

Dan Parker

11/29/2017 01:39PM

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

708

Peter Brawley

11/29/2017 04:21PM

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

749

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

802

Dan Parker

11/29/2017 05:25PM

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

719

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

851

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

719

Peter Brawley

12/01/2017 11:02AM

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

714

Dan Parker

12/01/2017 11:05AM

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

783

Peter Brawley

12/01/2017 11:19AM

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

825

Dan Parker

12/01/2017 11:26AM

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

716

Peter Brawley

12/01/2017 01:04PM

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

763

Dan Parker

12/01/2017 01:10PM

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

754

Peter Brawley

12/01/2017 05:01PM

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

805

Ø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,051

Patrick Meredith

11/27/2017 10:47AM

Re: Confirmation on possible parser bug

557

Peter Brawley

11/30/2017 11:20AM

Source code question related to sql_optimizer.cc line 8583

1,202

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

Edwin Desouza

11/17/2017 09:50AM

Is Union Queries run in Parallel form or not.

1,471

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.

782

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

947

Edwin Desouza

10/04/2017 06:03PM

Grammer Rule for Parenthesis in Select Statement

1,105

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

545

Peter Brawley

08/16/2017 10:07AM

Optimizer Stablility

1,043

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

Priya Pawar

07/30/2017 11:01AM

Re: Way to avoid fragmentation of MySQL tables

827

Peter Brawley

07/30/2017 04:41PM

Re: Way to avoid fragmentation of MySQL tables

615

Priya Pawar

07/30/2017 11:10PM

MySQL 8.0.2: Introducing Window Functions

990

Edwin Desouza

07/18/2017 10:33AM

Can anyone help speed up this query?

1,195

Search Team

06/21/2017 11:07AM