MySQL Forums
Forum List  »  Optimizer & Parser
Announcements Last Post
•   MySQL Connector/J 5.1.49 GA has been released 04/29/2020 08:57AM
•   MySQL Cluster 7.3.29 has been released 04/29/2020 01:52AM
•   MySQL Cluster 7.5.18 has been released 04/28/2020 11:09AM
•   MySQL Cluster 7.6.14 has been released 04/28/2020 06:31AM
•   MySQL Cluster 7.4.28 has been released 04/28/2020 04:08AM

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

Subject
Views
Written By
Posted
suggestion for optimizing with non-matching compound indexes  
4,472
Nathan Cheng
03/08/2006 12:39PM
Re: suggestion for optimizing with non-matching compound indexes  
2,080
Harrison Fisk
03/16/2006 11:40AM
Re: suggestion for optimizing with non-matching compound indexes  
1,995
Nathan Cheng
03/16/2006 12:15PM
Re: suggestion for optimizing with non-matching compound indexes  
2,705
Björn Steinbrink
03/22/2006 09:48AM
Re: suggestion for optimizing with non-matching compound indexes  
1,918
Björn Steinbrink
03/22/2006 09:12PM
Re: suggestion for optimizing with non-matching compound indexes  
1,897
Björn Steinbrink
03/24/2006 11:02AM
Query Optimization  
2,497
Jorden Dunne
03/21/2006 06:10AM
Re: Query Optimization  
1,662
Peter Brawley
03/21/2006 08:24AM
Re: Query Optimization  
1,636
Jorden Dunne
03/21/2006 09:19AM
Re: Query Optimization  
1,761
Peter Brawley
03/21/2006 11:24AM
Mysql high cpu usage problem  
2,565
vikki saggu
01/07/2006 02:29PM
Re: Mysql high cpu usage problem  
1,962
Bruno B.
01/31/2006 07:13AM
Re: Mysql high cpu usage problem  
2,333
Tobias Marx
03/20/2006 05:26PM
Query  
2,431
Jorge Ferreira
03/15/2006 11:08AM
Re: Query  
1,792
Jorge Ferreira
03/15/2006 11:17AM
Re: Query  
1,759
Jay Pipes
03/15/2006 11:37AM
Re: Query  
1,688
Jorge Ferreira
03/17/2006 08:38AM
my.cnf option file , which one to use ?  
2,987
Ilan Goldman
03/07/2006 02:48PM
UP , JUMP , PLEASE HELP  
1,772
Ilan Goldman
03/10/2006 04:19PM
How do I avoid "Using file sort" and "Using temporary"  
31,818
Solon Barns
03/03/2006 03:20PM
Re: How do I avoid "Using file sort" and "Using temporary"  
19,461
Solon Barns
03/10/2006 03:01PM
Re: How do I avoid "Using file sort" and "Using temporary"  
18,019
Jay Pipes
03/06/2006 10:16AM
Re: How do I avoid "Using file sort" and "Using temporary"  
16,227
Solon Barns
03/06/2006 12:51PM
Re: How do I avoid "Using file sort" and "Using temporary"  
17,714
Jay Pipes
03/07/2006 11:42AM
Re: How do I avoid "Using file sort" and "Using temporary"  
19,565
Jay Pipes
03/04/2006 11:46AM
Re: How do I avoid "Using file sort" and "Using temporary"  
18,104
Solon Barns
03/06/2006 08:27AM
MIN on an indexed field too slow  
3,759
Camelia Ticau
03/01/2006 01:58PM
Re: MIN on an indexed field too slow  
2,140
Björn Steinbrink
03/09/2006 06:04AM
Re: MIN on an indexed field too slow  
1,854
Apachez
03/02/2006 03:28PM
Re: MIN on an indexed field too slow  
1,914
Camelia Ticau
03/02/2006 11:38AM
Re: MIN on an indexed field too slow  
2,031
Apachez
03/01/2006 05:19PM
Re: MIN on an indexed field too slow  
2,015
Camelia Ticau
03/01/2006 04:54PM
Re: MIN on an indexed field too slow  
2,134
Apachez
03/01/2006 03:25PM
is HASH index being ignored  
3,522
Michal Carson
03/07/2006 10:17PM
Re: is HASH index being ignored  
1,968
Michal Carson
03/08/2006 10:59AM
Re: is HASH index being ignored  
1,966
Felix Geerinckx
03/08/2006 04:32AM
Re: is HASH index being ignored  
1,819
KimSeong Loh
03/08/2006 07:50PM
Urgent Optimized QUERY needed::  
2,950
Mohammed Abdullah All Marbin
03/04/2006 03:27PM
Re: Urgent Optimized QUERY needed::  
1,764
Bob Field
03/04/2006 04:33PM
Big MyISAM table with 3500 insertions per second behaviour  
4,257
Victor Perez Roche
02/20/2006 07:55AM
Re: Big MyISAM table with 3500 insertions per second behaviour  
1,996
Edwin DeSouza
02/22/2006 01:39PM
Re: Big MyISAM table with 3500 insertions per second behaviour  
1,925
Victor Perez Roche
02/28/2006 07:33AM
Re: Big MyISAM table with 3500 insertions per second behaviour  
1,854
Edwin DeSouza
03/03/2006 04:14PM
Re: Big MyISAM table with 3500 insertions per second behaviour  
2,093
Victor Perez Roche
02/20/2006 12:05PM
Re: Big MyISAM table with 3500 insertions per second behaviour  
2,021
Olaf van der Spek
02/20/2006 09:20AM
Range query performance question  
6,234
Camelia Ticau
02/27/2006 01:52PM
Re: Range query performance question  
2,454
Jay Pipes
02/27/2006 02:50PM
TINYINT(1) or ENUM( 'true' , 'false')  
29,282
yoderek
02/23/2006 01:56PM
Re: TINYINT(1) or ENUM( 'true' , 'false')  
12,376
Jay Pipes
02/23/2006 11:12PM
Need recommendation regarding IN expression  
2,942
Solon Barns
02/22/2006 12:52PM
Re: Need recommendation regarding IN expression  
1,988
Jay Pipes
02/22/2006 01:29PM
Re: Need recommendation regarding IN expression  
1,722
Solon Barns
02/23/2006 12:59AM
Re: Need recommendation regarding IN expression  
2,029
Jay Pipes
02/23/2006 10:55AM
slow subquery  
6,096
Michael Schnell
12/01/2005 03:33AM
Re: slow subquery  
5,038
Olaf van der Spek
02/23/2006 08:04AM
Re: slow subquery  
2,449
mysql.com
02/22/2006 01:06PM
Re: slow subquery  
2,447
Igor Babaev
12/19/2005 11:58PM
Re: slow subquery  
2,888
Matthias Horn
12/30/2005 12:43PM
Re: slow subquery (query is fast)  
3,195
Matthias Horn
12/30/2005 02:25PM
Re: slow subquery  
2,530
Michael Schnell
12/09/2005 02:32PM
Re: slow subquery  
2,703
Brian Moon
12/07/2005 08:18AM
possible_keys exist but key is NULL  
9,023
David McLaughlin
02/22/2006 11:29AM
Re: possible_keys exist but key is NULL  
3,965
Thomas CORBIERE
02/22/2006 02:12PM
"id IN (x,y)" versus "id=x OR id=y" with ORDER BY  
2,391
Robert Bergs
02/21/2006 07:00AM
what is sql.exe doing?  
3,525
Zilan Ciftci
02/19/2006 11:45AM
SUBQUERY PROBLEM AGAIN  
2,053
Odimar Tomazeli
02/17/2006 01:37PM
Subquery performance improvements: When?  
4,928
Olaf van der Spek
02/08/2006 10:07AM
Re: Subquery performance improvements: When?  
2,309
Olaf van der Spek
02/14/2006 08:31AM
Re: Subquery performance improvements: When?  
2,292
Robin Schumacher
02/09/2006 10:43AM
subquery workaround in MySQL 4.0.24  
2,538
Robert van Twillert
02/13/2006 12:47PM
SUBQUERY PROBLEM  
3,058
Odimar Tomazeli
02/07/2006 04:21PM
Re: SUBQUERY PROBLEM  
1,937
Odimar Tomazeli
02/13/2006 12:16PM
Re: SUBQUERY PROBLEM  
2,119
Odimar Tomazeli
02/13/2006 11:17AM
Re: SUBQUERY PROBLEM  
2,019
Jay Pipes
02/13/2006 11:22AM
Re: SUBQUERY PROBLEM  
2,180
Odimar Tomazeli
02/13/2006 11:06AM
Re: SUBQUERY PROBLEM  
2,002
Odimar Tomazeli
02/08/2006 08:37AM
Re: SUBQUERY PROBLEM - Optimizer Team  
2,004
Odimar Tomazeli
02/08/2006 10:26AM
Re: SUBQUERY PROBLEM  
2,066
Robin Schumacher
02/08/2006 04:57AM
Re: SUBQUERY PROBLEM  
1,933
Jay Pipes
02/08/2006 03:59PM
Re: SUBQUERY PROBLEM  
2,062
Jay Pipes
02/07/2006 04:45PM
Re: SUBQUERY PROBLEM  
1,965
Jay Pipes
02/07/2006 04:52PM
Subqueries too slow  
5,083
Andreas Schlicker
02/06/2006 11:08AM
Re: Subqueries too slow  
2,105
Andreas Schlicker
02/10/2006 09:49AM
Re: Subqueries too slow  
2,271
Jay Pipes
02/10/2006 10:43AM
Re: Subqueries too slow  
2,397
Andreas Schlicker
02/10/2006 03:18AM
Re: Subqueries too slow  
2,043
Jay Pipes
02/10/2006 08:51AM
Re: Subqueries too slow  
2,361
Andreas Schlicker
02/07/2006 08:38AM
Re: Subqueries too slow  
2,367
Robin Schumacher
02/06/2006 02:17PM
Re: Subqueries too slow  
2,347
Andreas Schlicker
02/07/2006 07:06AM
Re: Subqueries too slow  
2,569
Jay Pipes
02/06/2006 11:54AM
Is this query optimized?  
2,271
zaw sze
02/09/2006 09:44PM
Question about Handler_write  
3,060
Sebastien Caisse
02/09/2006 09:42AM
clash between unique and index keys  
5,693
Kenneth Vogt
02/08/2006 12:58AM
Re: clash between unique and index keys  
2,323
Kenneth Vogt
02/09/2006 12:04AM
Re: clash between unique and index keys  
2,589
Jay Pipes
02/08/2006 04:40PM
Re: clash between unique and index keys  
2,343
Kenneth Vogt
02/08/2006 05:44PM
Re: clash between unique and index keys  
2,513
Jay Pipes
02/08/2006 05:49PM
qcache_free_blocks  
7,985
Jacky Shu
02/07/2006 08:13AM
Re: qcache_free_blocks  
4,725
Jay Pipes
02/07/2006 10:10AM
Re: qcache_free_blocks  
4,070
Jacky Shu
02/07/2006 12:13PM
optimize  
2,902
edson fernando
01/17/2006 02:41PM
Re: optimize  
1,907
Sebastien Caisse
02/02/2006 09:02AM
Re: optimize  
1,943
edson fernando
01/18/2006 09:07AM
Re: optimize  
1,923
KimSeong Loh
01/17/2006 06:48PM
Double Index Performance  
7,921
Jawad Laraqui
01/12/2006 02:21PM
Re: Double Index Performance  
2,681
Sebastien Caisse
01/16/2006 06:24AM
Re: Double Index Performance  
2,737
Björn Steinbrink
01/16/2006 08:46AM
Re: Double Index Performance  
2,360
Sebastien Caisse
01/17/2006 06:45AM
Re: Double Index Performance  
2,582
Sebastien Caisse
02/01/2006 01:05PM
Re: Double Index Performance  
3,060
Björn Steinbrink
01/13/2006 05:18PM
'where' with 'in' doesn't use index?  
2,879
Vlado Kurelec
01/24/2006 05:25AM
Re: 'where' with 'in' doesn't use index?  
2,057
Vlado Kurelec
02/01/2006 06:24AM
Re: 'where' with 'in' doesn't use index?  
1,947
Robin Schumacher
01/30/2006 04:45PM
subquery breaks optimization  
2,622
Kiryll Mirnenko
01/20/2006 06:51AM
Re: subquery breaks optimization  
1,909
Robin Schumacher
01/24/2006 07:14PM
mysql dont use my Index?  
2,644
Johannes Fosseus
01/12/2006 08:22AM
Re: mysql dont use my Index?  
1,886
Jay Pipes
01/18/2006 10:36PM
does Select values effect index selection?  
2,794
ade br
01/10/2006 09:30AM
Re: does Select values effect index selection?  
1,879
Jay Pipes
01/10/2006 05:04PM
Optimizing with DATE()  
2,695
Paul Hartman
01/03/2006 02:28PM
Re: Optimizing with DATE()  
1,913
KimSeong Loh
01/03/2006 06:53PM
Simple Query - but explain worries me  
3,012
Jake Day
11/01/2005 01:26AM
Re: Simple Query - but explain worries me  
2,080
Jake Day
11/01/2005 02:48AM
Re: Simple Query - but explain worries me  
1,999
Konstantin Osipov
01/02/2006 05:22PM
Re: Simple Query - but explain worries me  
2,069
Vangelis Katsikaros
11/01/2005 03:05AM
Re: Simple Query - but explain worries me  
1,953
Jake Day
11/01/2005 05:13AM
Re: Simple Query - but explain worries me  
2,052
Vangelis Katsikaros
11/01/2005 05:57AM
Re: Simple Query - but explain worries me  
2,000
Jake Day
11/01/2005 07:37AM
Re: Simple Query - but explain worries me  
2,059
Jake Day
11/01/2005 08:03AM
select distinct slower in 5.0 than 4.1  
3,074
Saar Barhoom
12/18/2005 12:24PM
Re: select distinct slower in 5.0 than 4.1  
2,096
KimSeong Loh
12/27/2005 06:49PM
Re: select distinct slower in 5.0 than 4.1  
2,061
Peter Zaitsev
12/20/2005 08:29PM
Re: select distinct slower in 5.0 than 4.1  
2,110
Saar Barhoom
12/21/2005 03:15AM
Re: select distinct slower in 5.0 than 4.1  
2,164
Timour Katchaounov
12/29/2005 01:55AM
Re: select distinct slower in 5.0 than 4.1  
2,439
Jay Pipes
12/19/2005 10:49AM
Re: select distinct slower in 5.0 than 4.1  
2,179
Saar Barhoom
12/20/2005 10:29AM
Re: select distinct slower in 5.0 than 4.1  
2,113
Jay Pipes
12/20/2005 11:36AM
Re: select distinct slower in 5.0 than 4.1  
2,117
Saar Barhoom
12/21/2005 01:54AM
Range Join Performance  
3,971
Lionel Horn
11/23/2005 08:47AM
Re: Range Join Performance  
2,159
Jay Pipes
12/26/2005 07:56PM
Re: Range Join Performance  
2,120
Igor Babaev
12/21/2005 11:10PM
does my index take effect?  
3,059
zhenxing zhai
12/21/2005 03:19AM
Re: does my index take effect?  
1,929
Igor Babaev
12/21/2005 11:03PM
Index merge optimization with joined tables?  
3,277
Kayra Otaner
12/01/2005 11:39AM
Re: Index merge optimization with joined tables?  
2,024
Igor Babaev
12/21/2005 10:54PM
Re: Index merge optimization with joined tables?  
2,161
Brian Moon
12/07/2005 08:21AM
Re: Index merge optimization with joined tables?  
2,174
Jay Pipes
12/07/2005 05:37PM
explain + straight join oddity  
8,636
Stuart Maclean
12/20/2005 08:06PM
Re: explain + straight join oddity  
2,571
Igor Babaev
12/21/2005 10:44PM
Can't get my indexes right  
3,149
Tobias Ritzau
11/26/2005 04:53PM
Re: Can't get my indexes right  
2,029
Igor Babaev
12/21/2005 10:34PM
Re: Can't get my indexes right  
2,036
Tobias Ritzau
11/28/2005 02:19PM
Re: Can't get my indexes right  
1,921
Tobias Ritzau
11/28/2005 07:40AM
Re: Can't get my indexes right  
2,165
KimSeong Loh
11/28/2005 03:17AM
Re: Can't get my indexes right  
1,976
Tobias Ritzau
11/28/2005 02:44AM
Re: Can't get my indexes right  
2,112
KimSeong Loh
11/27/2005 07:28PM
optimization of left outer joins  
4,376
Clive Cox
12/16/2005 09:25AM
Re: optimization of left outer joins  
2,124
Igor Babaev
12/19/2005 11:42PM
Re: optimization of left outer joins  
2,568
Jay Pipes
12/16/2005 10:23AM
MySQL 5.0 optimizer: loose scans  
2,756
Edwin DeSouza
12/19/2005 01:46PM
Query Optimizer / SQL Translation  
3,966
Dave Wilson
11/28/2005 09:22PM
Re: Query Optimizer / SQL Translation  
2,291
Timour Katchaounov
12/14/2005 02:55AM
Group by Optimization  
6,841
Joe Genshlea
12/01/2005 08:27AM
Re: Group by Optimization  
7,395
Timour Katchaounov
12/14/2005 02:36AM
Re: Group by Optimization  
3,165
Jay Pipes
12/05/2005 11:29AM
Re: Group by Optimization  
3,723
Björn Steinbrink
12/03/2005 06:07AM
Re: Group by Optimization  
3,363
Jay Pipes
12/05/2005 11:32AM
Re: Group by Optimization  
3,214
Björn Steinbrink
12/09/2005 04:53PM
How to force the optimizer to use an index in a sub-query?  
6,602
Natalia Kuznesov
10/27/2005 10:43AM
Re: How to force the optimizer to use an index in a sub-query?  
3,446
Francisco Wong-Li
12/01/2005 01:51PM
why don't work for my substring index?  
4,187
zhenxing zhai
11/06/2005 10:09PM
Re: why don't work for my substring index?  
2,620
Francisco Wong-Li
12/01/2005 01:40PM
Re: why don't work for my substring index?  
2,496
zhenxing zhai
11/13/2005 09:23PM
Re: why don't work for my substring index?  
3,478
Felix Geerinckx
11/07/2005 05:13AM
Re: why don't work for my substring index?  
2,305
zhenxing zhai
11/09/2005 03:07AM
fast retrieval from MySQL database  
2,922
Akasmika Dash
11/21/2005 05:07AM
WHERE clause processing  
2,813
Maxx Kazimieszko
11/15/2005 05:20PM
Re: WHERE clause processing  
1,988
KimSeong Loh
11/15/2005 07:32PM
Eternal SELECT queries  
3,113
Aniceto Perez
11/15/2005 03:31AM
Re: Eternal SELECT queries  
2,130
Felix Geerinckx
11/15/2005 09:20AM
Performance of Select (pk) vs Select(*) with order by  
4,799
Alexander Hristov
11/07/2005 08:54AM
Re: Performance of Select (pk) vs Select(*) with order by  
3,196
KimSeong Loh
11/08/2005 07:15PM
Re: Performance of Select (pk) vs Select(*) with order by  
2,304
KimSeong Loh
11/07/2005 08:53PM
Re: Performance of Select (pk) vs Select(*) with order by  
4,258
Alexander Hristov
11/08/2005 03:53AM
Pages:
« 1
...
15 16 17 18 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.