MySQL Forums
Forum List  »  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

Advanced Search
New Topic
Pages:
« 1
...
9 10 11 12 13
...
19 »

Subject
Views
Written By
Posted
Why so great difference in so simple query ?  
3,341
Dmitriy Gorbenko
07/21/2009 11:37AM
Re: Why so great difference in so simple query ?  
2,062
Rick James
08/23/2009 06:57PM
sql trace  
3,258
Wilchard Oomens
08/07/2009 12:58AM
Re: sql trace  
2,138
Rick James
08/23/2009 06:48PM
Simplify optimization with distinct names  
3,363
Chris Hennick
08/19/2009 11:10AM
Re: Simplify optimization with distinct names  
2,165
Rick James
08/20/2009 09:05PM
MYSQL optimizer: Handling Subqueires  
3,300
Rakshit Trivedi
08/17/2009 05:50AM
Re: MYSQL optimizer: Handling Subqueires  
2,047
Rick James
08/18/2009 06:38PM
Re: MYSQL optimizer: Handling Subqueires  
2,109
Rakshit Trivedi
08/19/2009 03:33AM
Re: MYSQL optimizer: Handling Subqueires  
2,017
Rick James
08/19/2009 09:01PM
Re: MYSQL optimizer: Handling Subqueires  
2,012
Rakshit Trivedi
08/20/2009 09:34AM
Re: MYSQL optimizer: Handling Subqueires  
2,058
Rick James
08/20/2009 10:33AM
How to check table is successfully optimize?  
2,764
Syed Nabeel Anwer
08/19/2009 12:47AM
Re: How to check table is successfully optimize?  
2,313
Rick James
08/20/2009 10:20AM
Performance for bind variables & Tuning  
2,979
krunal pala
08/14/2009 03:19AM
Re: Performance for bind variables & Tuning  
2,670
Rick James
08/15/2009 02:49PM
Re: Performance for bind variables & Tuning  
2,196
krunal pala
08/17/2009 06:20AM
Re: Performance for bind variables & Tuning  
3,122
Rick James
08/17/2009 09:48AM
add a correct index, the same select statement becomes 5 times slower  
3,844
qiu cheng
05/27/2009 07:51PM
Re: add a correct index, the same select statement becomes 5 times slower  
2,130
shahbaz khan
08/16/2009 11:47AM
Re: add a correct index, the same select statement becomes 5 times slower  
2,194
Rick James
08/16/2009 03:54PM
Help optimizing dependant subqueries.  
2,956
Rob Hofmeyr
08/13/2009 01:43PM
Re: Help optimizing dependant subqueries.  
1,822
Rick James
08/15/2009 04:15PM
Three(or Four)-Way Joins  
3,737
Malcolm Wardlaw
08/11/2009 07:10PM
Re: Three(or Four)-Way Joins  
2,111
Rick James
08/12/2009 08:35PM
Re: Three(or Four)-Way Joins  
1,854
Malcolm Wardlaw
08/12/2009 09:31PM
Re: Three(or Four)-Way Joins  
1,960
Rick James
08/13/2009 12:16AM
Re: Three(or Four)-Way Joins  
1,941
Malcolm Wardlaw
08/13/2009 12:26PM
Re: Three(or Four)-Way Joins  
2,636
Rick James
08/13/2009 10:34PM
Create index for period of time  
3,374
Frank Schuster
07/28/2009 12:17AM
Re: Create index for period of time  
2,380
Rick James
08/08/2009 09:08PM
How to speed up the building of huge (>15 mln entries) normalized database?  
2,893
Kateryna Tymoshenko
07/27/2009 05:21AM
Re: How to speed up the building of huge (>15 mln entries) normalized database?  
1,786
Rick James
08/08/2009 08:59PM
How can I get the 'EXISTS' or 'IN' use an index?  
3,127
Johannes Fosseus
07/30/2009 04:39AM
Re: How can I get the 'EXISTS' or 'IN' use an index?  
1,927
Rick James
08/08/2009 04:44PM
JOINS AND INDEX NOT USED  
3,464
Steve Gore
07/30/2009 04:51PM
Re: JOINS AND INDEX NOT USED  
1,864
Rick James
08/07/2009 10:45PM
Simple query not using index  
4,402
Matthew Conway
08/05/2009 09:30AM
Re: Simple query not using index  
2,084
Matthew Conway
08/07/2009 04:15PM
Re: Simple query not using index  
2,327
Matthew Conway
08/07/2009 02:54PM
Using indexes with IN statement  
3,587
Dmitriy Gorbenko
07/21/2009 11:06AM
One Primary Key vs. Two  
3,118
Malcolm Wardlaw
07/19/2009 11:40AM
Query using "ref" instead of "range" access  
4,372
Keldon Jones
07/09/2009 04:52PM
Re: Query using "ref" instead of "range" access  
2,013
Rick James
07/11/2009 09:57PM
Re: Query using "ref" instead of "range" access  
2,230
Keldon Jones
07/11/2009 10:59PM
Re: Query using "ref" instead of "range" access  
2,151
Rick James
07/12/2009 09:32AM
Re: Query using "ref" instead of "range" access  
2,050
Keldon Jones
07/14/2009 04:37PM
How to select best keyword for optimization ?  
3,352
milly dou
07/07/2009 02:18AM
optimize mysql query  
4,271
andy susanto
06/27/2009 07:13PM
Optimizing Multiple ORDER BYs  
11,441
Sep Si
06/25/2009 07:50PM
Re: Optimizing Multiple ORDER BYs  
3,603
Rick James
06/27/2009 12:28AM
Query Optimization  
4,106
Nils Heldt
06/22/2009 03:46AM
Re: Query Optimization  
2,264
Rick James
06/23/2009 09:12AM
Re: Query Optimization  
2,209
Nils Heldt
06/24/2009 06:09AM
Query Optimization  
4,139
Praveen Kumar
06/15/2009 06:07AM
Re: Query Optimization  
2,279
Jani Patokallio
06/16/2009 03:43AM
Re: Query Optimization  
2,119
Rick James
06/16/2009 10:40PM
Top 10 airports referenced from a table of flights  
5,111
Jani Patokallio
06/09/2009 12:40AM
Re: Top 10 airports referenced from a table of flights  
2,188
Rick James
06/11/2009 10:46PM
Re: Top 10 airports referenced from a table of flights  
2,242
Rick James
06/11/2009 10:48PM
Re: Top 10 airports referenced from a table of flights  
2,354
Jani Patokallio
06/15/2009 10:16AM
Re: Top 10 airports referenced from a table of flights  
2,214
Rick James
06/15/2009 10:23PM
Re: Top 10 airports referenced from a table of flights  
3,274
Jani Patokallio
06/16/2009 03:35AM
multiple range query, using temporally and filesort  
3,972
Beer Bud
06/06/2009 10:44PM
Re: multiple range query, using temporally and filesort  
2,264
Rick James
06/08/2009 12:12AM
Query Optimization Help  
3,129
William Graham
06/04/2009 11:37AM
Re: Query Optimization Help  
2,131
Rick James
06/05/2009 08:37PM
Get rid of Temporary/filesort, rather simple query  
6,139
Reine n/a
06/01/2009 03:07AM
Re: Get rid of Temporary/filesort, rather simple query  
2,979
Rick James
06/02/2009 07:48PM
Re: Get rid of Temporary/filesort, rather simple query  
3,062
Reine n/a
06/03/2009 12:58AM
Re: Get rid of Temporary/filesort, rather simple query  
2,659
Rick James
06/03/2009 10:52PM
Re: Get rid of Temporary/filesort, rather simple query  
2,687
Reine n/a
06/04/2009 01:07AM
Re: Get rid of Temporary/filesort, rather simple query  
3,120
Rick James
06/04/2009 09:03AM
Re: Get rid of Temporary/filesort, rather simple query  
2,668
Reine n/a
06/04/2009 03:06PM
Re: Get rid of Temporary/filesort, rather simple query  
2,678
Rick James
06/04/2009 07:39PM
EXPLAIN Table reference order  
4,813
Sunil H
05/27/2009 01:06AM
Re: EXPLAIN Table reference order  
2,293
Rick James
05/28/2009 07:10PM
Table reordering of multi-table DELETE  
4,060
Saverio Miroddi
05/26/2009 03:43PM
Re: Table reordering of multi-table DELETE  
2,616
Rick James
05/27/2009 01:21AM
Re: Table reordering of multi-table DELETE  
2,302
Saverio Miroddi
05/27/2009 02:11AM
Re: Table reordering of multi-table DELETE  
2,285
Rick James
05/27/2009 09:52AM
Re: Table reordering of multi-table DELETE  
2,325
Saverio Miroddi
05/28/2009 07:10AM
Fast LIKE search  
15,247
andrew browne
05/23/2009 10:09AM
Re: Fast LIKE search  
6,856
Rick James
05/24/2009 12:41PM
Re: Fast LIKE search  
4,297
andrew browne
05/25/2009 12:58PM
Re: Fast LIKE search  
5,443
andrew browne
05/25/2009 10:27AM
Parallel scans  
3,811
Steve Fink
05/19/2009 04:15PM
Re: Parallel scans  
2,169
Rick James
05/20/2009 10:39PM
Nevermind. I'll program around it.  
3,020
Mark Marshall
05/18/2009 01:47PM
Re: Nevermind. I'll program around it.  
2,120
Rick James
05/19/2009 11:36PM
Need help :-(  
3,011
Shane Zammit
05/18/2009 04:36PM
Re: Need help :-(  
2,184
Rick James
05/19/2009 11:24PM
Query speed and columns per table  
3,832
Malcolm Wardlaw
05/18/2009 04:43PM
Re: Query speed and columns per table  
2,221
Rick James
05/19/2009 08:39PM
How to make this query faster? UNION + Inner Join  
10,484
Robin Bartholdson
02/21/2007 05:23AM
Re: How to make this query faster? UNION + Inner Join  
3,571
thina karan
05/16/2009 08:47AM
Re: How to make this query faster? UNION + Inner Join  
4,101
Rick James
05/16/2009 11:02PM
Simple queries hang on "statistics"  
4,743
Jay Paroline
05/01/2009 12:26PM
Re: Simple queries hang on "statistics"  
2,348
Jay Paroline
05/08/2009 03:12PM
Re: Simple queries hang on "statistics"  
2,515
Rick James
05/08/2009 09:00PM
Re: Simple queries hang on "statistics"  
2,493
Jay Paroline
05/12/2009 08:49AM
Re: Simple queries hang on "statistics"  
2,445
Rick James
05/01/2009 11:00PM
How to set limit to log & data files? - while running snort ids  
3,318
Anton A
04/27/2009 12:10PM
Re: How to set limit to log & data files? - while running snort ids  
2,441
Rick James
05/02/2009 12:51PM
Re: How to set limit to log & data files? - while running snort ids  
2,507
Anton A
05/07/2009 01:25AM
Re: How to set limit to log & data files? - while running snort ids  
2,325
Rick James
05/07/2009 07:22PM
Re: How to set limit to log & data files? - while running snort ids  
2,640
Anton A
05/07/2009 08:47PM
Re: How to set limit to log & data files? - while running snort ids  
2,310
Rick James
05/07/2009 11:56PM
The New MySQL Query Profiler and previous versions of MySQL  
3,584
Nikolas Branis
05/06/2009 03:41AM
Query taking a lot of time if there is no record in table  
5,526
Aditi mittal
04/29/2009 04:42AM
Re: Query taking a lot of time if there is no record in table  
2,436
Rick James
04/30/2009 11:31PM
Re: Query taking a lot of time if there is no record in table  
2,402
Aditi mittal
05/04/2009 01:30AM
Re: Query taking a lot of time if there is no record in table  
2,308
Rick James
05/04/2009 07:19PM
Re: Query taking a lot of time if there is no record in table  
2,380
Aditi mittal
05/04/2009 11:46PM
3 Table Join (indexed) results in where-temp-filesort  
5,064
Doug Crane
04/30/2009 08:21PM
Re: 3 Table Join (indexed) results in where-temp-filesort  
2,630
Rick James
05/03/2009 04:19PM
Re: 3 Table Join (indexed) results in where-temp-filesort  
2,403
Doug Crane
05/01/2009 07:22PM
Extremely large tables  
4,162
Malcolm Wardlaw
04/27/2009 09:30PM
Re: Extremely large tables  
2,309
Rick James
04/28/2009 11:01PM
Re: Extremely large tables  
2,462
Malcolm Wardlaw
05/01/2009 01:28PM
does unique index do more than just being a constraint?  
8,290
Martijn Groen
04/24/2009 08:29PM
Re: does unique index do more than just being a constraint?  
4,898
Rick James
04/25/2009 09:11PM
Error message when trying to optimize tables  
3,322
Keith Duncan
04/21/2009 01:04PM
Index not being used  
6,638
Patrick O'Loughlin
04/14/2009 05:18AM
Re: Index not being used  
3,256
Rick James
04/15/2009 10:41AM
Re: Index not being used  
3,029
Patrick O'Loughlin
04/21/2009 02:55AM
Unexpected join optimization  
3,607
Grace Zhu
04/17/2009 01:21PM
Re: Unexpected join optimization  
2,270
Grace Zhu
04/17/2009 02:36PM
LOW_PRIORIY, IGNORE, DELAY & QUICK  
3,199
sandeep gupta
04/09/2009 04:06AM
Re: LOW_PRIORIY, IGNORE, DELAY & QUICK  
2,522
Rick James
04/11/2009 03:27PM
Will a composed index help me?  
4,230
Alex P
04/09/2009 12:36AM
Re: Will a composed index help me?  
2,297
Rick James
04/10/2009 10:31AM
Help with index in a view. Index not used. MySql Bug?  
6,381
Emilio Nicolás
04/01/2009 03:02AM
Re: Help with index in a view. Index not used. MySql Bug?  
3,346
Emilio Nicolás
04/02/2009 02:26AM
Re: Help with index in a view. Index not used. MySql Bug?  
3,320
Emilio Nicolás
04/06/2009 04:20PM
Re: Help with index in a view. Index not used. MySql Bug?  
3,234
Rick James
04/04/2009 10:11PM
Re: Help with index in a view. Index not used. MySql Bug?  
3,142
Emilio Nicolás
04/05/2009 01:08PM
update query optimization  
4,164
rajesh vijayan
04/02/2009 02:17AM
Re: update query optimization  
2,429
Rick James
04/03/2009 06:43PM
Use of DISTINCT in INNER JOIN  
69,166
Steve Croall
03/24/2009 12:07PM
Re: Use of DISTINCT in INNER JOIN  
6,878
Rick James
03/25/2009 07:01PM
Re: Use of DISTINCT in INNER JOIN  
6,568
Steve Croall
03/27/2009 05:20AM
Re: Use of DISTINCT in INNER JOIN  
5,806
Rick James
03/27/2009 10:01AM
Re: Use of DISTINCT in INNER JOIN  
6,750
Steve Croall
03/28/2009 02:02AM
Re: Use of DISTINCT in INNER JOIN  
4,632
Rick James
03/28/2009 03:53PM
Re: Use of DISTINCT in INNER JOIN  
5,823
Steve Croall
04/01/2009 03:36AM
Re: Use of DISTINCT in INNER JOIN  
6,116
Rick James
04/02/2009 12:16AM
Re: Use of DISTINCT in INNER JOIN  
5,578
Steve Croall
04/02/2009 06:29AM
Re: Use of DISTINCT in INNER JOIN  
11,136
Steve Croall
03/24/2009 02:00PM
Query multiple table  
6,934
prem budhu
03/29/2009 05:14PM
Re: Query multiple table  
2,644
Rick James
03/30/2009 07:16PM
Pages:
« 1
...
9 10 11 12 13
...
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.