MySQL Forums
Forum List  »  Optimizer & Parser

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,241
Dmitriy Gorbenko
07/21/2009 11:37AM
Re: Why so great difference in so simple query ?  
2,028
Rick James
08/23/2009 06:57PM
sql trace  
3,183
Wilchard Oomens
08/07/2009 12:58AM
Re: sql trace  
2,099
Rick James
08/23/2009 06:48PM
Simplify optimization with distinct names  
3,281
Chris Hennick
08/19/2009 11:10AM
Re: Simplify optimization with distinct names  
2,121
Rick James
08/20/2009 09:05PM
MYSQL optimizer: Handling Subqueires  
3,193
Rakshit Trivedi
08/17/2009 05:50AM
Re: MYSQL optimizer: Handling Subqueires  
2,008
Rick James
08/18/2009 06:38PM
Re: MYSQL optimizer: Handling Subqueires  
2,076
Rakshit Trivedi
08/19/2009 03:33AM
Re: MYSQL optimizer: Handling Subqueires  
1,981
Rick James
08/19/2009 09:01PM
Re: MYSQL optimizer: Handling Subqueires  
1,969
Rakshit Trivedi
08/20/2009 09:34AM
Re: MYSQL optimizer: Handling Subqueires  
2,025
Rick James
08/20/2009 10:33AM
How to check table is successfully optimize?  
2,685
Syed Nabeel Anwer
08/19/2009 12:47AM
Re: How to check table is successfully optimize?  
2,277
Rick James
08/20/2009 10:20AM
Performance for bind variables & Tuning  
2,901
krunal pala
08/14/2009 03:19AM
Re: Performance for bind variables & Tuning  
2,611
Rick James
08/15/2009 02:49PM
Re: Performance for bind variables & Tuning  
2,165
krunal pala
08/17/2009 06:20AM
Re: Performance for bind variables & Tuning  
3,079
Rick James
08/17/2009 09:48AM
add a correct index, the same select statement becomes 5 times slower  
3,760
qiu cheng
05/27/2009 07:51PM
Re: add a correct index, the same select statement becomes 5 times slower  
2,090
shahbaz khan
08/16/2009 11:47AM
Re: add a correct index, the same select statement becomes 5 times slower  
2,140
Rick James
08/16/2009 03:54PM
Help optimizing dependant subqueries.  
2,868
Rob Hofmeyr
08/13/2009 01:43PM
Re: Help optimizing dependant subqueries.  
1,785
Rick James
08/15/2009 04:15PM
Three(or Four)-Way Joins  
3,653
Malcolm Wardlaw
08/11/2009 07:10PM
Re: Three(or Four)-Way Joins  
2,069
Rick James
08/12/2009 08:35PM
Re: Three(or Four)-Way Joins  
1,810
Malcolm Wardlaw
08/12/2009 09:31PM
Re: Three(or Four)-Way Joins  
1,920
Rick James
08/13/2009 12:16AM
Re: Three(or Four)-Way Joins  
1,900
Malcolm Wardlaw
08/13/2009 12:26PM
Re: Three(or Four)-Way Joins  
2,594
Rick James
08/13/2009 10:34PM
Create index for period of time  
3,286
Frank Schuster
07/28/2009 12:17AM
Re: Create index for period of time  
2,338
Rick James
08/08/2009 09:08PM
How to speed up the building of huge (>15 mln entries) normalized database?  
2,820
Kateryna Tymoshenko
07/27/2009 05:21AM
Re: How to speed up the building of huge (>15 mln entries) normalized database?  
1,741
Rick James
08/08/2009 08:59PM
How can I get the 'EXISTS' or 'IN' use an index?  
3,050
Johannes Fosseus
07/30/2009 04:39AM
Re: How can I get the 'EXISTS' or 'IN' use an index?  
1,875
Rick James
08/08/2009 04:44PM
JOINS AND INDEX NOT USED  
3,375
Steve Gore
07/30/2009 04:51PM
Re: JOINS AND INDEX NOT USED  
1,816
Rick James
08/07/2009 10:45PM
Simple query not using index  
4,315
Matthew Conway
08/05/2009 09:30AM
Re: Simple query not using index  
2,038
Matthew Conway
08/07/2009 04:15PM
Re: Simple query not using index  
2,282
Matthew Conway
08/07/2009 02:54PM
Using indexes with IN statement  
3,492
Dmitriy Gorbenko
07/21/2009 11:06AM
One Primary Key vs. Two  
3,027
Malcolm Wardlaw
07/19/2009 11:40AM
Query using "ref" instead of "range" access  
4,242
Keldon Jones
07/09/2009 04:52PM
Re: Query using "ref" instead of "range" access  
1,965
Rick James
07/11/2009 09:57PM
Re: Query using "ref" instead of "range" access  
2,186
Keldon Jones
07/11/2009 10:59PM
Re: Query using "ref" instead of "range" access  
2,107
Rick James
07/12/2009 09:32AM
Re: Query using "ref" instead of "range" access  
2,013
Keldon Jones
07/14/2009 04:37PM
How to select best keyword for optimization ?  
3,281
milly dou
07/07/2009 02:18AM
optimize mysql query  
4,168
andy susanto
06/27/2009 07:13PM
Optimizing Multiple ORDER BYs  
11,336
Sep Si
06/25/2009 07:50PM
Re: Optimizing Multiple ORDER BYs  
3,563
Rick James
06/27/2009 12:28AM
Query Optimization  
4,015
Nils Heldt
06/22/2009 03:46AM
Re: Query Optimization  
2,216
Rick James
06/23/2009 09:12AM
Re: Query Optimization  
2,178
Nils Heldt
06/24/2009 06:09AM
Query Optimization  
4,009
Praveen Kumar
06/15/2009 06:07AM
Re: Query Optimization  
2,239
Jani Patokallio
06/16/2009 03:43AM
Re: Query Optimization  
2,073
Rick James
06/16/2009 10:40PM
Top 10 airports referenced from a table of flights  
4,970
Jani Patokallio
06/09/2009 12:40AM
Re: Top 10 airports referenced from a table of flights  
2,149
Rick James
06/11/2009 10:46PM
Re: Top 10 airports referenced from a table of flights  
2,182
Rick James
06/11/2009 10:48PM
Re: Top 10 airports referenced from a table of flights  
2,301
Jani Patokallio
06/15/2009 10:16AM
Re: Top 10 airports referenced from a table of flights  
2,174
Rick James
06/15/2009 10:23PM
Re: Top 10 airports referenced from a table of flights  
3,226
Jani Patokallio
06/16/2009 03:35AM
multiple range query, using temporally and filesort  
3,885
Beer Bud
06/06/2009 10:44PM
Re: multiple range query, using temporally and filesort  
2,226
Rick James
06/08/2009 12:12AM
Query Optimization Help  
3,017
William Graham
06/04/2009 11:37AM
Re: Query Optimization Help  
2,084
Rick James
06/05/2009 08:37PM
Get rid of Temporary/filesort, rather simple query  
6,014
Reine n/a
06/01/2009 03:07AM
Re: Get rid of Temporary/filesort, rather simple query  
2,926
Rick James
06/02/2009 07:48PM
Re: Get rid of Temporary/filesort, rather simple query  
3,009
Reine n/a
06/03/2009 12:58AM
Re: Get rid of Temporary/filesort, rather simple query  
2,616
Rick James
06/03/2009 10:52PM
Re: Get rid of Temporary/filesort, rather simple query  
2,637
Reine n/a
06/04/2009 01:07AM
Re: Get rid of Temporary/filesort, rather simple query  
3,057
Rick James
06/04/2009 09:03AM
Re: Get rid of Temporary/filesort, rather simple query  
2,623
Reine n/a
06/04/2009 03:06PM
Re: Get rid of Temporary/filesort, rather simple query  
2,617
Rick James
06/04/2009 07:39PM
EXPLAIN Table reference order  
4,719
Sunil H
05/27/2009 01:06AM
Re: EXPLAIN Table reference order  
2,251
Rick James
05/28/2009 07:10PM
Table reordering of multi-table DELETE  
3,979
Saverio Miroddi
05/26/2009 03:43PM
Re: Table reordering of multi-table DELETE  
2,580
Rick James
05/27/2009 01:21AM
Re: Table reordering of multi-table DELETE  
2,266
Saverio Miroddi
05/27/2009 02:11AM
Re: Table reordering of multi-table DELETE  
2,244
Rick James
05/27/2009 09:52AM
Re: Table reordering of multi-table DELETE  
2,291
Saverio Miroddi
05/28/2009 07:10AM
Fast LIKE search  
15,176
andrew browne
05/23/2009 10:09AM
Re: Fast LIKE search  
6,766
Rick James
05/24/2009 12:41PM
Re: Fast LIKE search  
4,264
andrew browne
05/25/2009 12:58PM
Re: Fast LIKE search  
5,406
andrew browne
05/25/2009 10:27AM
Parallel scans  
3,694
Steve Fink
05/19/2009 04:15PM
Re: Parallel scans  
2,135
Rick James
05/20/2009 10:39PM
Nevermind. I'll program around it.  
2,953
Mark Marshall
05/18/2009 01:47PM
Re: Nevermind. I'll program around it.  
2,089
Rick James
05/19/2009 11:36PM
Need help :-(  
2,933
Shane Zammit
05/18/2009 04:36PM
Re: Need help :-(  
2,147
Rick James
05/19/2009 11:24PM
Query speed and columns per table  
3,747
Malcolm Wardlaw
05/18/2009 04:43PM
Re: Query speed and columns per table  
2,180
Rick James
05/19/2009 08:39PM
How to make this query faster? UNION + Inner Join  
10,390
Robin Bartholdson
02/21/2007 05:23AM
Re: How to make this query faster? UNION + Inner Join  
3,525
thina karan
05/16/2009 08:47AM
Re: How to make this query faster? UNION + Inner Join  
4,054
Rick James
05/16/2009 11:02PM
Simple queries hang on "statistics"  
4,664
Jay Paroline
05/01/2009 12:26PM
Re: Simple queries hang on "statistics"  
2,305
Jay Paroline
05/08/2009 03:12PM
Re: Simple queries hang on "statistics"  
2,467
Rick James
05/08/2009 09:00PM
Re: Simple queries hang on "statistics"  
2,442
Jay Paroline
05/12/2009 08:49AM
Re: Simple queries hang on "statistics"  
2,396
Rick James
05/01/2009 11:00PM
How to set limit to log & data files? - while running snort ids  
3,226
Anton A
04/27/2009 12:10PM
Re: How to set limit to log & data files? - while running snort ids  
2,389
Rick James
05/02/2009 12:51PM
Re: How to set limit to log & data files? - while running snort ids  
2,459
Anton A
05/07/2009 01:25AM
Re: How to set limit to log & data files? - while running snort ids  
2,282
Rick James
05/07/2009 07:22PM
Re: How to set limit to log & data files? - while running snort ids  
2,593
Anton A
05/07/2009 08:47PM
Re: How to set limit to log & data files? - while running snort ids  
2,255
Rick James
05/07/2009 11:56PM
The New MySQL Query Profiler and previous versions of MySQL  
3,507
Nikolas Branis
05/06/2009 03:41AM
Query taking a lot of time if there is no record in table  
5,360
Aditi mittal
04/29/2009 04:42AM
Re: Query taking a lot of time if there is no record in table  
2,384
Rick James
04/30/2009 11:31PM
Re: Query taking a lot of time if there is no record in table  
2,348
Aditi mittal
05/04/2009 01:30AM
Re: Query taking a lot of time if there is no record in table  
2,263
Rick James
05/04/2009 07:19PM
Re: Query taking a lot of time if there is no record in table  
2,300
Aditi mittal
05/04/2009 11:46PM
3 Table Join (indexed) results in where-temp-filesort  
4,929
Doug Crane
04/30/2009 08:21PM
Re: 3 Table Join (indexed) results in where-temp-filesort  
2,577
Rick James
05/03/2009 04:19PM
Re: 3 Table Join (indexed) results in where-temp-filesort  
2,358
Doug Crane
05/01/2009 07:22PM
Extremely large tables  
4,055
Malcolm Wardlaw
04/27/2009 09:30PM
Re: Extremely large tables  
2,264
Rick James
04/28/2009 11:01PM
Re: Extremely large tables  
2,402
Malcolm Wardlaw
05/01/2009 01:28PM
does unique index do more than just being a constraint?  
8,134
Martijn Groen
04/24/2009 08:29PM
Re: does unique index do more than just being a constraint?  
4,836
Rick James
04/25/2009 09:11PM
Error message when trying to optimize tables  
3,216
Keith Duncan
04/21/2009 01:04PM
Index not being used  
6,314
Patrick O'Loughlin
04/14/2009 05:18AM
Re: Index not being used  
3,186
Rick James
04/15/2009 10:41AM
Re: Index not being used  
2,978
Patrick O'Loughlin
04/21/2009 02:55AM
Unexpected join optimization  
3,419
Grace Zhu
04/17/2009 01:21PM
Re: Unexpected join optimization  
2,204
Grace Zhu
04/17/2009 02:36PM
LOW_PRIORIY, IGNORE, DELAY & QUICK  
3,112
sandeep gupta
04/09/2009 04:06AM
Re: LOW_PRIORIY, IGNORE, DELAY & QUICK  
2,472
Rick James
04/11/2009 03:27PM
Will a composed index help me?  
4,140
Alex P
04/09/2009 12:36AM
Re: Will a composed index help me?  
2,249
Rick James
04/10/2009 10:31AM
Help with index in a view. Index not used. MySql Bug?  
6,239
Emilio Nicolás
04/01/2009 03:02AM
Re: Help with index in a view. Index not used. MySql Bug?  
3,287
Emilio Nicolás
04/02/2009 02:26AM
Re: Help with index in a view. Index not used. MySql Bug?  
3,270
Emilio Nicolás
04/06/2009 04:20PM
Re: Help with index in a view. Index not used. MySql Bug?  
3,194
Rick James
04/04/2009 10:11PM
Re: Help with index in a view. Index not used. MySql Bug?  
3,083
Emilio Nicolás
04/05/2009 01:08PM
update query optimization  
4,085
rajesh vijayan
04/02/2009 02:17AM
Re: update query optimization  
2,387
Rick James
04/03/2009 06:43PM
Use of DISTINCT in INNER JOIN  
67,470
Steve Croall
03/24/2009 12:07PM
Re: Use of DISTINCT in INNER JOIN  
6,776
Rick James
03/25/2009 07:01PM
Re: Use of DISTINCT in INNER JOIN  
6,475
Steve Croall
03/27/2009 05:20AM
Re: Use of DISTINCT in INNER JOIN  
5,701
Rick James
03/27/2009 10:01AM
Re: Use of DISTINCT in INNER JOIN  
6,653
Steve Croall
03/28/2009 02:02AM
Re: Use of DISTINCT in INNER JOIN  
4,555
Rick James
03/28/2009 03:53PM
Re: Use of DISTINCT in INNER JOIN  
5,742
Steve Croall
04/01/2009 03:36AM
Re: Use of DISTINCT in INNER JOIN  
6,017
Rick James
04/02/2009 12:16AM
Re: Use of DISTINCT in INNER JOIN  
5,499
Steve Croall
04/02/2009 06:29AM
Re: Use of DISTINCT in INNER JOIN  
10,968
Steve Croall
03/24/2009 02:00PM
Query multiple table  
6,793
prem budhu
03/29/2009 05:14PM
Re: Query multiple table  
2,592
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.