MySQL :: MySQL Forums :: Optimizer & Parser

Announcements	Last Post
• Announcing April 2025 Releases featuring MySQL Server 9.3.0 Innovation, 8.4.5 LTS and 8.0.42	04/16/2025 12:35PM

New Topic

Pages:

« 1

...

11 12 13 14 15

...

19 »

Subject

Views

Written By

Posted

which is better filesort or temporary?

3,764

amit bhat

06/09/2008 06:24AM

Re: which is better filesort or temporary?

2,369

KimSeong Loh

06/09/2008 06:22PM

Re: which is better filesort or temporary?

2,367

amit bhat

06/13/2008 03:55AM

Re: which is better filesort or temporary?

2,221

Rick James

09/26/2008 11:50PM

Automatic creation and inserting to a new table = database or application level?

3,638

Eddie Jr. Panes

07/23/2008 08:02AM

Re: Automatic creation and inserting to a new table = database or application level?

2,252

Rick James

09/26/2008 11:47PM

inner join on range criteria: unable to use index?

10,408

Joseph Fisk

08/11/2008 04:34PM

Re: inner join on range criteria: unable to use index?

3,707

Joseph Fisk

08/12/2008 12:52PM

Re: inner join on range criteria: unable to use index?

3,057

Rick James

09/26/2008 11:38PM

Re: inner join on range criteria: unable to use index?

3,689

KimSeong Loh

08/11/2008 05:56PM

Re: inner join on range criteria: unable to use index?

3,750

Joseph Fisk

08/11/2008 06:04PM

Re: inner join on range criteria: unable to use index?

3,566

KimSeong Loh

08/12/2008 01:38AM

Re: inner join on range criteria: unable to use index?

3,236

Joseph Fisk

08/12/2008 09:30AM

Re: inner join on range criteria: unable to use index?

3,180

KimSeong Loh

08/12/2008 07:11PM

Aplication running clow

4,082

Agus Himalaya

08/28/2008 09:17PM

Re: Aplication running clow

2,268

Rick James

09/26/2008 11:22PM

QUERY OPTIMIZATION FOR UNION ALL IN MYSQL 4.1.22

8,944

aswini nayak

09/03/2008 03:30AM

Re: QUERY OPTIMIZATION FOR UNION ALL IN MYSQL 4.1.22

2,783

Rick James

09/26/2008 11:20PM

Question about EXPLAIN output

3,381

eli cohen

09/19/2008 02:47PM

Re: Question about EXPLAIN output

2,187

KimSeong Loh

09/19/2008 09:40PM

java.sql.SQLException: maxBlockcount [5] reached!

3,152

Holger Thiel

09/15/2008 02:52AM

Please help? another newbie substring problem

3,457

Gregg Rene

09/10/2008 09:52AM

Re: Please help? another newbie substring problem

2,129

KimSeong Loh

09/11/2008 06:06PM

UNIONs faster than simple joins

12,618

Michael B Allen

09/04/2008 10:12AM

Re: UNIONs faster than simple ORs

3,061

Rick James

09/06/2008 10:44PM

Re: UNIONs faster than simple ORs

3,223

Michael B Allen

09/09/2008 12:16PM

Optimize a query fetching huge data

6,209

Radhika Mehta

04/16/2008 01:21AM

Re: Optimize a query fetching huge data

2,973

Rick James

09/01/2008 12:02AM

Re: Optimize a query fetching huge data

2,831

Anil Pathak

07/22/2008 03:33AM

single sweep multi join in combination with where

5,795

Mert Sonsuz

07/27/2008 07:03AM

Re: single sweep multi join in combination with where

2,353

Rick James

08/31/2008 11:57PM

Using Filesort and Temporary... Help?

3,605

Adam Bratt

08/28/2008 12:36AM

Re: Using Filesort and Temporary... Help?

2,466

Rick James

08/31/2008 11:52PM

long time processing long query

6,312

Some One

05/22/2008 12:52PM

Re: long time processing long query

2,665

Some One

05/25/2008 08:09AM

Re: long time processing long query

2,381

Rick James

08/31/2008 11:44PM

Please help me optimize this query

3,160

Robert Kern

07/28/2008 05:23PM

Re: Please help me optimize this query

2,057

Rick James

08/31/2008 11:40PM

Query - delay 20 segs

4,983

Ricardo Takemura

08/04/2008 06:25AM

Re: Query - delay 20 segs

2,468

Rick James

08/31/2008 11:31PM

Re: Query - delay 20 segs

2,480

Ricardo Takemura

08/04/2008 06:26AM

index selection

6,535

Jordi Prats

08/07/2008 06:01AM

Re: index selection

2,613

KimSeong Loh

08/07/2008 07:07PM

Re: index selection

2,653

Shlomi Noach

08/30/2008 11:48AM

Re: index selection

2,493

Rick James

08/31/2008 11:16PM

Prevent DISTINCT from using temporary tables

13,391

Eric Lyons

08/25/2008 09:07PM

Re: Prevent DISTINCT from using temporary tables

6,705

Shlomi Noach

08/30/2008 11:42AM

Adding current entry to previous with join

3,730

Kevin Regan

07/29/2008 06:50PM

Re: Adding current entry to previous with join

2,271

KimSeong Loh

07/29/2008 07:31PM

Re: Adding current entry to previous with join

2,204

Kevin Regan

07/30/2008 01:05AM

log-queries-not-using-indexes and "Using index" in the Extra col of Explain

4,792

MFTree MFTree

07/28/2008 01:10PM

Jabar Query

3,027

zain alam

07/16/2008 12:01AM

Query long time

3,682

Sahid Ferdjaoui

07/08/2008 02:25AM

Re: Query long time

2,267

KimSeong Loh

07/08/2008 04:33AM

Re: Query long time

2,306

Sahid Ferdjaoui

07/08/2008 05:39AM

substr, update, index wont like each other

8,017

Pavan Kumar

05/15/2008 12:58PM

Re: substr, update, index wont like each other

2,965

Lars Johansson

05/17/2008 10:56PM

what's the use of mysql optimizer_search_depth

5,699

Gavin Zhang

05/12/2008 01:24AM

Re: what's the use of mysql optimizer_search_depth

3,040

KimSeong Loh

05/12/2008 03:02AM

Re: what's the use of mysql optimizer_search_depth

2,854

Gavin Zhang

05/12/2008 01:25AM

Optimized join - is CONCAT optimized ?

4,449

S F

05/12/2008 02:50AM

Re: Optimized join - is CONCAT optimized ?

2,444

KimSeong Loh

05/12/2008 03:02AM

is index have expired time?

3,762

Alpha Centauri

05/05/2008 11:19AM

Re: is index have expired time?

2,321

Alpha Centauri

05/09/2008 12:24PM

Re: is index have expired time?

2,305

KimSeong Loh

05/09/2008 05:01PM

Como aumento el maximo de conusltas permitidas de mysql?

3,121

Luis Ernesto Castillo

05/05/2008 11:18AM

query cache & Using temporary

4,094

Tsvetomir Denev

05/02/2008 09:51AM

Re: query cache & Using temporary

2,551

Tsvetomir Denev

05/02/2008 03:35PM

This is strange

3,588

brian clarke

01/29/2008 05:27AM

Re: This is strange

2,300

hieu ngoc

04/04/2008 12:35AM

How to optimize an ORDER BY query using a range to avoid any filesorts

12,420

Faury Rodriguez

10/14/2007 12:57PM

Re: How to optimize an ORDER BY query using a range to avoid any filesorts

3,814

sukh gill

03/28/2008 10:57PM

Re: How to optimize an ORDER BY query using a range to avoid any filesorts

7,369

KimSeong Loh

10/14/2007 05:44PM

Re: How to optimize an ORDER BY query using a range to avoid any filesorts

5,206

Faury Rodriguez

10/14/2007 11:21PM

Re: How to optimize an ORDER BY query using a range to avoid any filesorts

4,991

KimSeong Loh

10/15/2007 02:18AM

Re: How to optimize an ORDER BY query using a range to avoid any filesorts

4,733

Faury Rodriguez

10/15/2007 03:44AM

Re: How to optimize an ORDER BY query using a range to avoid any filesorts

4,576

KimSeong Loh

10/15/2007 04:22PM

Re: How to optimize an ORDER BY query using a range to avoid any filesorts

4,575

Faury Rodriguez

10/24/2007 02:27PM

Re: How to optimize an ORDER BY query using a range to avoid any filesorts

4,340

KimSeong Loh

10/24/2007 04:35PM

Profiler not present in MySql 5.0.56-log ?

4,117

Benjamin Fonze

03/28/2008 07:34AM

The 7 seconds query

3,420

Tobias Marx

03/24/2008 05:50AM

Re: The 7 seconds query

2,345

Tobias Marx

03/24/2008 06:20AM

find next lowest value in lookup table?

6,187

Matthias Fripp

03/21/2008 06:03PM

Flush

5,884

Wayne Lee

03/18/2008 02:19AM

Re: Flush

2,498

KimSeong Loh

03/18/2008 04:15PM

Please help to optimize slow running query

3,655

sus moh

03/07/2008 12:40AM

Re: Please help to optimize slow running query

2,481

Björn Steinbrink

03/16/2008 06:31AM

Indexes and bit functions?

3,070

Victor Svetogor

03/14/2008 03:08AM

Query not returning all rows.. system Variables

5,178

Anna Sobiepanek

03/12/2008 09:29AM

Re: Query not returning all rows.. system Variables

2,475

Anna Sobiepanek

03/12/2008 12:12PM

performence monitor and analyzing tool

3,762

Dan Echo

01/13/2008 06:06PM

Re: performence monitor and analyzing tool

2,367

Marek Podmaka

03/12/2008 09:57AM

Another question about index's

3,299

Daniel Silva

01/05/2008 06:35PM

Re: Another question about index's

2,251

Marek Podmaka

03/12/2008 09:55AM

Searching for a user across two tables taking 23 seconds

3,526

Tom Beharrell

11/05/2007 04:24PM

Re: Searching for a user across two tables taking 23 seconds

2,239

Marek Podmaka

03/12/2008 09:49AM

performance issue on simple table access via primary key

3,758

Maggie Pong

12/11/2007 12:42AM

Re: performance issue on simple table access via primary key

2,424

Marek Podmaka

03/12/2008 09:44AM

Problem using LIKE with FORCE INDEX...

8,199

Jonathan Segura Castro

02/04/2008 11:02AM

Re: Problem using LIKE with FORCE INDEX...

4,265

Faury Rodriguez

02/04/2008 05:08PM

Re: Problem using LIKE with FORCE INDEX...

3,633

Chaitanya Jakhadi

02/06/2008 02:34AM

Re: Problem using LIKE with FORCE INDEX...

3,490

KimSeong Loh

02/13/2008 01:19AM

Re: Problem using LIKE with FORCE INDEX...

3,463

Marek Podmaka

03/12/2008 09:40AM

Many Table Scanned instead of One table.

3,464

Don Thompson

02/15/2008 10:36AM

Re: Many Table Scanned instead of One table.

2,259

Marek Podmaka

03/12/2008 09:37AM

selects with multiple categories

4,076

Marek Podmaka

03/12/2008 09:28AM

Help Optimizing Query

3,712

Matt Clements

02/15/2008 06:52PM

Re: Help Optimizing Query

2,339

e h

02/21/2008 07:50PM

Re: Help Optimizing Query

2,392

Ryan Lowe

02/17/2008 09:13PM

How to optimize this query?

3,387

Andrea Buccella

02/18/2008 05:46AM

Double COUNT & Double LEFT JOIN

16,228

Olexandr Novosad

06/01/2007 04:56AM

Re: Clustring

3,427

zafar hussain

02/13/2008 05:14AM

Query optimization on INSERT ... SELECT ... SUBSTR

11,250

Jess Mann

01/25/2008 12:29PM

Re: Query optimization on INSERT ... SELECT ... SUBSTR

3,309

Björn Steinbrink

02/11/2008 12:03AM

Re: Query optimization on INSERT ... SELECT ... SUBSTR

3,229

Jess Mann

02/09/2008 05:25PM

Static (non correlated) sub-query instead of a join

6,112

Dewey Gaedcke

01/12/2008 08:43AM

Re: Static (non correlated) sub-query instead of a join

2,739

Dewey Gaedcke

01/14/2008 04:15PM

is there a way to block backup privileges

3,462

Raymond Davis

12/27/2007 10:40AM

Re: is there a way to block backup privileges

2,252

Ryan Lowe

01/10/2008 10:46AM

45 million row table - Two BETWEENs not using a composite index optimally

5,257

Tasman Hayes

08/06/2007 12:42AM

Re: 45 million row table - Two BETWEENs not using a composite index optimally

2,635

wes mahler

12/22/2007 10:54AM

Pages:

« 1

...

11 12 13 14 15

...

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.