MySQL Forums
Forum List  »  Optimizer & Parser

Advanced Search
New Topic
Pages:
« 1
...
13 14 15 16 17
...
19 »

Subject
Views
Written By
Posted
Large IN() Comparison Optimize Help  
2,533
Garrett Gyssler
02/11/2007 02:51AM
How should I index the tables in this query?  
2,681
Dan Bress
02/09/2007 01:35PM
Substring ignores index  
6,652
Matt Ryan
09/29/2006 08:59AM
Re: Substring ignores index  
3,530
Toa Sty
09/29/2006 09:48AM
Re: Substring ignores index  
2,813
Denver Vender
02/09/2007 04:01AM
Help required in optimizing query  
2,954
Albert Arul prakash Rajendran
02/08/2007 09:43PM
intense query with "union"  
2,329
asif baloch
02/07/2007 04:54PM
my boss says mysql is not upto standard: Please reply urgent  
2,429
jatin shah
02/06/2007 06:05AM
Re: my boss says mysql is not upto standard: Please reply urgent  
1,824
Toa Sty
02/06/2007 09:31AM
Simple queries take a lot some times  
2,391
Paolo Ragone
01/30/2007 01:04PM
ORDER BY + LIMIT  
4,470
Markus Doppelbauer
11/12/2006 04:45AM
Re: ORDER BY + LIMIT  
3,172
Toa Sty
11/12/2006 08:27AM
Re: ORDER BY + LIMIT  
2,952
Markus Doppelbauer
11/12/2006 12:09PM
Re: ORDER BY + LIMIT  
30,196
Toa Sty
11/13/2006 04:40AM
Re: ORDER BY + LIMIT  
3,504
Markus Doppelbauer
01/30/2007 12:06PM
bug?? partial index gives wrong results with IN subquery  
2,749
Paul Davies
01/29/2007 08:44AM
File Sort  
2,707
aftab khan
01/25/2007 08:49AM
Re: File Sort  
1,889
KimSeong Loh
01/26/2007 07:50AM
SQL Newbie needs urgently help! [optimizing query]  
3,311
Toxic Head
01/24/2007 05:31AM
Re: SQL Newbie needs urgently help! [optimizing query]  
2,197
Toxic Head
01/24/2007 05:52AM
Re: SQL Newbie needs urgently help! [optimizing query]  
2,102
Toa Sty
01/24/2007 06:07AM
Re: SQL Newbie needs urgently help! [optimizing query]  
2,156
Toxic Head
01/24/2007 06:18AM
Re: SQL Newbie needs urgently help! [optimizing query]  
2,013
Toa Sty
01/24/2007 07:16AM
Re: SQL Newbie needs urgently help! [optimizing query]  
2,196
Toxic Head
01/24/2007 07:32AM
Re: SQL Newbie needs urgently help! [optimizing query]  
2,030
Toxic Head
01/24/2007 06:41AM
Re: SQL Newbie needs urgently help! [optimizing query]  
2,030
Toxic Head
01/24/2007 07:16AM
Re: SQL Newbie needs urgently help! [optimizing query]  
2,100
Toa Sty
01/24/2007 08:16AM
Re: SQL Newbie needs urgently help! [optimizing query]  
2,193
Toxic Head
01/24/2007 08:50AM
Re: SQL Newbie needs urgently help! [optimizing query]  
2,129
Toxic Head
01/24/2007 09:24AM
Re: SQL Newbie needs urgently help! [optimizing query]  
2,055
Björn Steinbrink
01/24/2007 03:19PM
Re: SQL Newbie needs urgently help! [optimizing query]  
1,985
Toxic Head
01/25/2007 07:27AM
Re: SQL Newbie needs urgently help! [optimizing query]  
2,231
Toa Sty
01/24/2007 10:29AM
Re: SQL Newbie needs urgently help! [optimizing query]  
2,115
Toxic Head
01/24/2007 10:40AM
Re: SQL Newbie needs urgently help! [optimizing query]  
2,066
Toa Sty
01/24/2007 09:10AM
need solution for ORDER BY and COUNT  
2,880
Konstantin S.
01/25/2007 05:46AM
Need help optmizing query  
2,419
Pascual Angulo
01/16/2007 03:58PM
Re: Need help optmizing query  
1,924
KimSeong Loh
01/16/2007 06:42PM
How to optimize a derived table required for re-ordering.  
3,673
Vikash Bucha
11/25/2006 05:58AM
Re: How to optimize a derived table required for re-ordering.  
2,893
Toa Sty
01/15/2007 08:41AM
Help optimizing a slow query entry  
2,807
Patrick
01/12/2007 10:28AM
Re: Help optimizing a slow query entry  
1,851
Toa Sty
01/15/2007 08:30AM
Having problems with ORDER BY COUNT  
13,971
steed coptang
04/29/2006 08:56AM
Re: Having problems with ORDER BY COUNT  
4,999
Omar Khan
01/15/2007 03:35AM
Re: Having problems with ORDER BY COUNT  
4,552
Toa Sty
01/15/2007 08:28AM
Problems optimize query  
3,640
Rafal Kedziorski
01/08/2007 05:14PM
Make this faster?  
3,439
Levi Tedder
01/04/2007 07:38AM
Re: Make this faster?  
2,192
Björn Steinbrink
01/04/2007 03:34PM
Re: Make this faster?  
2,145
Levi Tedder
01/05/2007 02:40AM
Re: Make this faster?  
2,093
Björn Steinbrink
01/05/2007 05:07AM
Re: Make this faster?  
2,085
Levi Tedder
01/05/2007 08:31AM
Re: Make this faster?  
2,122
Toa Sty
01/05/2007 08:45AM
Re: Make this faster?  
2,128
Levi Tedder
01/08/2007 02:44AM
Re: Make this faster?  
2,074
Toa Sty
01/08/2007 04:28AM
Re: Make this faster?  
2,096
Levi Tedder
01/08/2007 04:41AM
Re: Make this faster?  
2,222
Levi Tedder
01/05/2007 03:11PM
Re: Make this faster?  
2,091
Felix Geerinckx
01/05/2007 06:55AM
Re: Make this faster?  
2,122
Toa Sty
01/05/2007 08:31AM
Re: Make this faster?  
2,146
Levi Tedder
01/05/2007 08:33AM
Re: Make this faster?  
2,250
Toa Sty
01/05/2007 08:45AM
Re: Make this faster?  
2,132
Toa Sty
01/04/2007 10:21AM
Re: Make this faster?  
2,093
Levi Tedder
01/04/2007 11:51AM
REGEXP is not optimized?  
3,179
Maarten Oosten
12/15/2006 07:54AM
Re: REGEXP is not optimized?  
2,337
Toa Sty
01/05/2007 08:57AM
Two general MySQL questions  
4,116
Joost
01/02/2007 09:24AM
Re: Two general MySQL questions  
2,060
KimSeong Loh
01/02/2007 08:11PM
Re: Two general MySQL questions  
2,021
Joost
01/03/2007 05:35PM
Re: Two general MySQL questions  
2,055
KimSeong Loh
01/03/2007 06:10PM
Re: Two general MySQL questions  
2,032
Joost
01/04/2007 05:49AM
Re: Two general MySQL questions  
2,028
Toa Sty
01/04/2007 10:53AM
i've got the query optimization blues ... stumped  
2,764
Joe Simone
12/15/2006 02:48PM
Re: i've got the query optimization blues ... stumped  
1,964
Toa Sty
01/04/2007 10:32AM
How to optimize the "order by" & "limit" query?  
3,074
Jiangyubao Jiangyubao
12/18/2006 09:48AM
Re: How to optimize the "order by" & "limit" query?  
2,104
Toa Sty
01/04/2007 10:25AM
parallelizing queries  
2,468
Niklas Saers
01/02/2007 05:59AM
Query with GROUP BY (Using index for group-by -> Using index)  
9,205
mnf
11/30/2006 05:20AM
Re: Query with GROUP BY (Using index for group-by -> Using index)  
3,168
mnf
12/06/2006 02:03AM
Re: Query with GROUP BY (Using index for group-by -> Using index)  
2,977
KimSeong Loh
12/07/2006 12:19AM
Re: Query with GROUP BY (Using index for group-by -> Using index)  
3,051
mnf
12/25/2006 06:35AM
Re: Query with GROUP BY (Using index for group-by -> Using index)  
3,475
KimSeong Loh
11/30/2006 08:18PM
Re: Query with GROUP BY (Using index for group-by -> Using index)  
3,461
mnf
12/01/2006 12:21AM
optimization with table_cache  
49,822
rei
09/05/2006 09:17PM
Re: optimization with table_cache  
19,725
Björn Steinbrink
12/20/2006 02:45AM
Re: optimization with table_cache  
20,272
sneakyimp
12/18/2006 10:40PM
Re: optimization with table_cache  
20,083
Björn Steinbrink
12/20/2006 02:37AM
Optimizer Tool  
2,970
Danie Van der Walt
09/04/2006 03:10AM
Re: Optimizer Tool  
2,120
Yogesh Salvi
12/13/2006 04:57AM
Re: Optimizer Tool  
3,250
KimSeong Loh
12/13/2006 07:39PM
Creating an index to include ORDER BY  
2,925
Angus
11/02/2006 08:28AM
Re: Creating an index to include ORDER BY  
1,843
KimSeong Loh
11/02/2006 05:31PM
Re: Creating an index to include ORDER BY  
1,940
Angus
11/03/2006 09:24AM
Re: Creating an index to include ORDER BY  
1,899
Yogesh Salvi
12/13/2006 05:02AM
Bad performance caused by DISTINCT?  
8,239
Heist TheAlmighty
11/13/2006 02:02PM
Re: Bad performance caused by DISTINCT?  
3,260
Yogesh Salvi
12/13/2006 04:46AM
Re: Bad performance caused by DISTINCT?  
4,210
KimSeong Loh
11/19/2006 09:29PM
Two possible indexes in simple select but none is used  
3,065
Ozkan Mehmedali
11/28/2006 10:40AM
Re: Two possible indexes in simple select but none is used  
1,815
Yogesh Salvi
12/13/2006 04:41AM
Re: Two possible indexes in simple select but none is used  
1,845
KimSeong Loh
11/28/2006 06:27PM
how turn off optimizer?  
2,908
krix asdasd
11/28/2006 11:40AM
Re: how turn off optimizer?  
2,680
KimSeong Loh
11/28/2006 06:25PM
Re: how turn off optimizer?  
2,545
krix asdasd
11/30/2006 02:04AM
Re: how turn off optimizer?  
2,154
Dewey Gaedcke
12/12/2006 06:24PM
Re: how turn off optimizer?  
2,173
Dewey Gaedcke
11/28/2006 11:24PM
Golden Rules of writting efficient query  
7,900
Yogesh Salvi
11/23/2006 01:37AM
Re: Golden Rules of writting efficient query  
2,341
Satya Prakash
12/08/2006 08:28AM
Re: Golden Rules of writting efficient query  
3,075
KimSeong Loh
11/23/2006 02:17AM
Liberating Dependent Subqueries  
13,789
Shlomo Swidler
11/27/2006 05:50PM
A more general way to do it  
3,837
Shlomo Swidler
12/05/2006 08:43AM
Improvements to "constify"  
3,633
Shlomo Swidler
12/07/2006 06:26AM
Re: Liberating Dependent Subqueries  
2,935
mnf
12/01/2006 09:35AM
Re: Liberating Dependent Subqueries  
2,637
KimSeong Loh
12/03/2006 06:21PM
Re: Liberating Dependent Subqueries  
2,679
mnf
12/03/2006 08:18PM
Re: Liberating Dependent Subqueries  
2,706
Shlomo Swidler
12/05/2006 06:11AM
Re: Liberating Dependent Subqueries  
3,256
KimSeong Loh
11/28/2006 06:29PM
Re: Liberating Dependent Subqueries  
4,026
Shlomo Swidler
11/30/2006 05:39PM
Re: Liberating Dependent Subqueries  
3,664
Vikash Bucha
11/28/2006 12:57AM
Re: Liberating Dependent Subqueries  
3,329
Shlomo Swidler
11/28/2006 03:09AM
Update with dependent subquery needs optimization!  
3,952
Lon B
12/06/2006 05:23PM
Re: Update with dependent subquery needs optimization!  
2,051
Björn Steinbrink
12/07/2006 02:04AM
optimizer using sql_no_cache  
3,755
alan langridge
12/06/2006 07:56AM
Re: optimizer using sql_no_cache  
1,898
alan langridge
12/06/2006 11:07AM
Optimizing a query  
2,629
Ryan Smith
11/28/2006 10:37AM
Re: Optimizing a query  
1,790
KimSeong Loh
11/28/2006 06:28PM
Join with more strict condition shows the record which is not visible without it  
3,012
Michal Jaskolski
11/24/2006 06:08AM
Multiple join and Where clause  
41,788
michele terlizzi
11/15/2006 05:13AM
Re: Multiple join and Where clause  
6,651
Björn Steinbrink
11/22/2006 04:20PM
Including set type in index  
3,926
Angus
11/10/2006 01:56PM
Re: Including set type in index  
2,300
KimSeong Loh
11/12/2006 06:55PM
Re: Including set type in index  
2,111
Angus
11/13/2006 09:36AM
to save as text block? or to save as rows?  
2,733
ryan morris
11/10/2006 06:09PM
ignore  
2,422
chris bagnall
11/10/2006 03:44AM
deleting approx. 180m records a month  
2,749
Nolan Rumble
11/06/2006 03:09PM
Re: deleting approx. 180m records a month  
1,868
KimSeong Loh
11/06/2006 07:04PM
Query cache  
2,611
Markus Doppelbauer
10/31/2006 01:32PM
Re: Query cache  
1,907
Toa Sty
10/31/2006 04:12PM
Re: Query cache  
1,871
Markus Doppelbauer
11/01/2006 06:27AM
Re: Query cache  
1,899
Michael Dar
11/01/2006 12:25PM
Re: Query cache  
1,960
Toa Sty
11/02/2006 03:11AM
optimizing abs()  
2,996
Michiel Betel
10/25/2006 04:31AM
Re: optimizing abs()  
2,136
Toa Sty
10/25/2006 05:37AM
Re: optimizing abs()  
1,877
Michiel Betel
10/29/2006 07:31AM
Optimizer ignores datetime index  
4,998
Angus
10/27/2006 09:51AM
Re: Optimizer ignores datetime index  
3,318
Toa Sty
10/27/2006 12:48PM
Re: Optimizer ignores datetime index  
2,688
Angus
10/27/2006 01:09PM
Derived tables optimized differently than when directly queried?  
3,729
Tom Callahan
10/25/2006 02:38PM
Re: Derived tables optimized differently than when directly queried?  
2,004
Björn Steinbrink
10/26/2006 05:33PM
Simple Query - No Join - But Temp. Table and file Sort :(  
3,795
Heiko G.
10/21/2006 09:06AM
Re: Simple Query - No Join - But Temp. Table and file Sort :(  
2,377
Toa Sty
10/21/2006 10:55AM
Re: Simple Query - No Join - But Temp. Table and file Sort :(  
2,769
Heiko G.
10/22/2006 04:56AM
Re: Simple Query - No Join - But Temp. Table and file Sort :(  
2,180
Heiko G.
10/21/2006 11:17AM
Re: Simple Query - No Join - But Temp. Table and file Sort :(  
2,710
Toa Sty
10/23/2006 06:41AM
Re: Simple Query - No Join - But Temp. Table and file Sort :(  
2,505
Heiko G.
10/23/2006 11:02AM
Re: Simple Query - No Join - But Temp. Table and file Sort :(  
2,158
Toa Sty
10/23/2006 01:01PM
Re: Simple Query - No Join - But Temp. Table and file Sort :(  
2,510
Ravenous Bugblatter Beast
10/21/2006 05:20PM
Optimizer ignores number of records  
2,565
Lite Wait
09/15/2006 06:28AM
Re: Optimizer ignores number of records  
1,808
Ravenous Bugblatter Beast
10/21/2006 05:05AM
Performance of two similar Selects  
2,681
Jay Klein
10/12/2006 06:34PM
Re: Performance of two similar Selects  
1,814
Toa Sty
10/17/2006 02:07PM
How to speed up query of indexed column with 5M rows?  
23,839
ryan zheng
10/09/2006 06:34AM
Re: How to speed up query of indexed column with 5M rows?  
4,911
KimSeong Loh
10/09/2006 07:54PM
Re: How to speed up query of indexed column with 5M rows?  
6,313
Toa Sty
10/09/2006 09:40AM
Re: How to speed up query of indexed column with 5M rows?  
5,928
ryan zheng
10/09/2006 08:39PM
Re: How to speed up query of indexed column with 5M rows?  
8,801
Larry Kagan
10/09/2006 08:11AM
Re: How to speed up query of indexed column with 5M rows?  
7,324
ryan zheng
10/10/2006 12:23AM
Re: How to speed up query of indexed column with 5M rows?  
6,404
Björn Steinbrink
10/12/2006 07:57PM
Re: How to speed up query of indexed column with 5M rows?  
6,678
Larry Kagan
10/10/2006 08:45AM
Deactivate an activate Database  
9,549
Sudipta Ghosh
10/06/2006 06:37AM
Re: Deactivate an activate Database  
3,504
Bob Field
10/06/2006 09:35AM
Re: Deactivate an activate Database  
3,011
Sudipta Ghosh
10/06/2006 11:12PM
Re: Deactivate an activate Database  
2,843
Bob Field
10/06/2006 11:48PM
Pages:
« 1
...
13 14 15 16 17
...
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.