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,474
Dmitriy Gorbenko
07/21/2009 11:37AM
Re: Why so great difference in so simple query ?  
2,122
Rick James
08/23/2009 06:57PM
sql trace  
3,381
Wilchard Oomens
08/07/2009 12:58AM
Re: sql trace  
2,184
Rick James
08/23/2009 06:48PM
Simplify optimization with distinct names  
3,462
Chris Hennick
08/19/2009 11:10AM
Re: Simplify optimization with distinct names  
2,209
Rick James
08/20/2009 09:05PM
MYSQL optimizer: Handling Subqueires  
3,400
Rakshit Trivedi
08/17/2009 05:50AM
Re: MYSQL optimizer: Handling Subqueires  
2,110
Rick James
08/18/2009 06:38PM
Re: MYSQL optimizer: Handling Subqueires  
2,152
Rakshit Trivedi
08/19/2009 03:33AM
Re: MYSQL optimizer: Handling Subqueires  
2,088
Rick James
08/19/2009 09:01PM
Re: MYSQL optimizer: Handling Subqueires  
2,061
Rakshit Trivedi
08/20/2009 09:34AM
Re: MYSQL optimizer: Handling Subqueires  
2,122
Rick James
08/20/2009 10:33AM
How to check table is successfully optimize?  
2,909
Syed Nabeel Anwer
08/19/2009 12:47AM
Re: How to check table is successfully optimize?  
2,366
Rick James
08/20/2009 10:20AM
Performance for bind variables & Tuning  
3,072
krunal pala
08/14/2009 03:19AM
Re: Performance for bind variables & Tuning  
2,735
Rick James
08/15/2009 02:49PM
Re: Performance for bind variables & Tuning  
2,250
krunal pala
08/17/2009 06:20AM
Re: Performance for bind variables & Tuning  
3,181
Rick James
08/17/2009 09:48AM
add a correct index, the same select statement becomes 5 times slower  
3,938
qiu cheng
05/27/2009 07:51PM
Re: add a correct index, the same select statement becomes 5 times slower  
2,187
shahbaz khan
08/16/2009 11:47AM
Re: add a correct index, the same select statement becomes 5 times slower  
2,259
Rick James
08/16/2009 03:54PM
Help optimizing dependant subqueries.  
3,050
Rob Hofmeyr
08/13/2009 01:43PM
Re: Help optimizing dependant subqueries.  
1,864
Rick James
08/15/2009 04:15PM
Three(or Four)-Way Joins  
3,860
Malcolm Wardlaw
08/11/2009 07:10PM
Re: Three(or Four)-Way Joins  
2,156
Rick James
08/12/2009 08:35PM
Re: Three(or Four)-Way Joins  
1,913
Malcolm Wardlaw
08/12/2009 09:31PM
Re: Three(or Four)-Way Joins  
2,002
Rick James
08/13/2009 12:16AM
Re: Three(or Four)-Way Joins  
1,989
Malcolm Wardlaw
08/13/2009 12:26PM
Re: Three(or Four)-Way Joins  
2,685
Rick James
08/13/2009 10:34PM
Create index for period of time  
3,473
Frank Schuster
07/28/2009 12:17AM
Re: Create index for period of time  
2,441
Rick James
08/08/2009 09:08PM
How to speed up the building of huge (>15 mln entries) normalized database?  
3,014
Kateryna Tymoshenko
07/27/2009 05:21AM
Re: How to speed up the building of huge (>15 mln entries) normalized database?  
1,855
Rick James
08/08/2009 08:59PM
How can I get the 'EXISTS' or 'IN' use an index?  
3,220
Johannes Fosseus
07/30/2009 04:39AM
Re: How can I get the 'EXISTS' or 'IN' use an index?  
1,986
Rick James
08/08/2009 04:44PM
JOINS AND INDEX NOT USED  
3,561
Steve Gore
07/30/2009 04:51PM
Re: JOINS AND INDEX NOT USED  
1,916
Rick James
08/07/2009 10:45PM
Simple query not using index  
4,500
Matthew Conway
08/05/2009 09:30AM
Re: Simple query not using index  
2,139
Matthew Conway
08/07/2009 04:15PM
Re: Simple query not using index  
2,379
Matthew Conway
08/07/2009 02:54PM
Using indexes with IN statement  
3,694
Dmitriy Gorbenko
07/21/2009 11:06AM
One Primary Key vs. Two  
3,209
Malcolm Wardlaw
07/19/2009 11:40AM
Query using "ref" instead of "range" access  
4,532
Keldon Jones
07/09/2009 04:52PM
Re: Query using "ref" instead of "range" access  
2,062
Rick James
07/11/2009 09:57PM
Re: Query using "ref" instead of "range" access  
2,273
Keldon Jones
07/11/2009 10:59PM
Re: Query using "ref" instead of "range" access  
2,205
Rick James
07/12/2009 09:32AM
Re: Query using "ref" instead of "range" access  
2,113
Keldon Jones
07/14/2009 04:37PM
How to select best keyword for optimization ?  
3,456
milly dou
07/07/2009 02:18AM
optimize mysql query  
4,391
andy susanto
06/27/2009 07:13PM
Optimizing Multiple ORDER BYs  
11,549
Sep Si
06/25/2009 07:50PM
Re: Optimizing Multiple ORDER BYs  
3,647
Rick James
06/27/2009 12:28AM
Query Optimization  
4,210
Nils Heldt
06/22/2009 03:46AM
Re: Query Optimization  
2,336
Rick James
06/23/2009 09:12AM
Re: Query Optimization  
2,255
Nils Heldt
06/24/2009 06:09AM
Query Optimization  
4,270
Praveen Kumar
06/15/2009 06:07AM
Re: Query Optimization  
2,336
Jani Patokallio
06/16/2009 03:43AM
Re: Query Optimization  
2,180
Rick James
06/16/2009 10:40PM
Top 10 airports referenced from a table of flights  
5,222
Jani Patokallio
06/09/2009 12:40AM
Re: Top 10 airports referenced from a table of flights  
2,254
Rick James
06/11/2009 10:46PM
Re: Top 10 airports referenced from a table of flights  
2,300
Rick James
06/11/2009 10:48PM
Re: Top 10 airports referenced from a table of flights  
2,410
Jani Patokallio
06/15/2009 10:16AM
Re: Top 10 airports referenced from a table of flights  
2,277
Rick James
06/15/2009 10:23PM
Re: Top 10 airports referenced from a table of flights  
3,345
Jani Patokallio
06/16/2009 03:35AM
multiple range query, using temporally and filesort  
4,073
Beer Bud
06/06/2009 10:44PM
Re: multiple range query, using temporally and filesort  
2,319
Rick James
06/08/2009 12:12AM
Query Optimization Help  
3,248
William Graham
06/04/2009 11:37AM
Re: Query Optimization Help  
2,193
Rick James
06/05/2009 08:37PM
Get rid of Temporary/filesort, rather simple query  
6,266
Reine n/a
06/01/2009 03:07AM
Re: Get rid of Temporary/filesort, rather simple query  
3,032
Rick James
06/02/2009 07:48PM
Re: Get rid of Temporary/filesort, rather simple query  
3,112
Reine n/a
06/03/2009 12:58AM
Re: Get rid of Temporary/filesort, rather simple query  
2,706
Rick James
06/03/2009 10:52PM
Re: Get rid of Temporary/filesort, rather simple query  
2,737
Reine n/a
06/04/2009 01:07AM
Re: Get rid of Temporary/filesort, rather simple query  
3,183
Rick James
06/04/2009 09:03AM
Re: Get rid of Temporary/filesort, rather simple query  
2,722
Reine n/a
06/04/2009 03:06PM
Re: Get rid of Temporary/filesort, rather simple query  
2,725
Rick James
06/04/2009 07:39PM
EXPLAIN Table reference order  
4,908
Sunil H
05/27/2009 01:06AM
Re: EXPLAIN Table reference order  
2,345
Rick James
05/28/2009 07:10PM
Table reordering of multi-table DELETE  
4,186
Saverio Miroddi
05/26/2009 03:43PM
Re: Table reordering of multi-table DELETE  
2,668
Rick James
05/27/2009 01:21AM
Re: Table reordering of multi-table DELETE  
2,358
Saverio Miroddi
05/27/2009 02:11AM
Re: Table reordering of multi-table DELETE  
2,341
Rick James
05/27/2009 09:52AM
Re: Table reordering of multi-table DELETE  
2,378
Saverio Miroddi
05/28/2009 07:10AM
Fast LIKE search  
15,347
andrew browne
05/23/2009 10:09AM
Re: Fast LIKE search  
6,910
Rick James
05/24/2009 12:41PM
Re: Fast LIKE search  
4,355
andrew browne
05/25/2009 12:58PM
Re: Fast LIKE search  
5,503
andrew browne
05/25/2009 10:27AM
Parallel scans  
3,989
Steve Fink
05/19/2009 04:15PM
Re: Parallel scans  
2,231
Rick James
05/20/2009 10:39PM
Nevermind. I'll program around it.  
3,123
Mark Marshall
05/18/2009 01:47PM
Re: Nevermind. I'll program around it.  
2,177
Rick James
05/19/2009 11:36PM
Need help :-(  
3,108
Shane Zammit
05/18/2009 04:36PM
Re: Need help :-(  
2,239
Rick James
05/19/2009 11:24PM
Query speed and columns per table  
3,937
Malcolm Wardlaw
05/18/2009 04:43PM
Re: Query speed and columns per table  
2,274
Rick James
05/19/2009 08:39PM
How to make this query faster? UNION + Inner Join  
10,577
Robin Bartholdson
02/21/2007 05:23AM
Re: How to make this query faster? UNION + Inner Join  
3,617
thina karan
05/16/2009 08:47AM
Re: How to make this query faster? UNION + Inner Join  
4,154
Rick James
05/16/2009 11:02PM
Simple queries hang on "statistics"  
4,851
Jay Paroline
05/01/2009 12:26PM
Re: Simple queries hang on "statistics"  
2,395
Jay Paroline
05/08/2009 03:12PM
Re: Simple queries hang on "statistics"  
2,574
Rick James
05/08/2009 09:00PM
Re: Simple queries hang on "statistics"  
2,548
Jay Paroline
05/12/2009 08:49AM
Re: Simple queries hang on "statistics"  
2,517
Rick James
05/01/2009 11:00PM
How to set limit to log & data files? - while running snort ids  
3,450
Anton A
04/27/2009 12:10PM
Re: How to set limit to log & data files? - while running snort ids  
2,496
Rick James
05/02/2009 12:51PM
Re: How to set limit to log & data files? - while running snort ids  
2,565
Anton A
05/07/2009 01:25AM
Re: How to set limit to log & data files? - while running snort ids  
2,378
Rick James
05/07/2009 07:22PM
Re: How to set limit to log & data files? - while running snort ids  
2,698
Anton A
05/07/2009 08:47PM
Re: How to set limit to log & data files? - while running snort ids  
2,370
Rick James
05/07/2009 11:56PM
The New MySQL Query Profiler and previous versions of MySQL  
3,691
Nikolas Branis
05/06/2009 03:41AM
Query taking a lot of time if there is no record in table  
5,679
Aditi mittal
04/29/2009 04:42AM
Re: Query taking a lot of time if there is no record in table  
2,505
Rick James
04/30/2009 11:31PM
Re: Query taking a lot of time if there is no record in table  
2,455
Aditi mittal
05/04/2009 01:30AM
Re: Query taking a lot of time if there is no record in table  
2,366
Rick James
05/04/2009 07:19PM
Re: Query taking a lot of time if there is no record in table  
2,438
Aditi mittal
05/04/2009 11:46PM
3 Table Join (indexed) results in where-temp-filesort  
5,220
Doug Crane
04/30/2009 08:21PM
Re: 3 Table Join (indexed) results in where-temp-filesort  
2,688
Rick James
05/03/2009 04:19PM
Re: 3 Table Join (indexed) results in where-temp-filesort  
2,464
Doug Crane
05/01/2009 07:22PM
Extremely large tables  
4,269
Malcolm Wardlaw
04/27/2009 09:30PM
Re: Extremely large tables  
2,363
Rick James
04/28/2009 11:01PM
Re: Extremely large tables  
2,519
Malcolm Wardlaw
05/01/2009 01:28PM
does unique index do more than just being a constraint?  
8,455
Martijn Groen
04/24/2009 08:29PM
Re: does unique index do more than just being a constraint?  
4,950
Rick James
04/25/2009 09:11PM
Error message when trying to optimize tables  
3,437
Keith Duncan
04/21/2009 01:04PM
Index not being used  
6,957
Patrick O'Loughlin
04/14/2009 05:18AM
Re: Index not being used  
3,299
Rick James
04/15/2009 10:41AM
Re: Index not being used  
3,113
Patrick O'Loughlin
04/21/2009 02:55AM
Unexpected join optimization  
3,732
Grace Zhu
04/17/2009 01:21PM
Re: Unexpected join optimization  
2,321
Grace Zhu
04/17/2009 02:36PM
LOW_PRIORIY, IGNORE, DELAY & QUICK  
3,303
sandeep gupta
04/09/2009 04:06AM
Re: LOW_PRIORIY, IGNORE, DELAY & QUICK  
2,579
Rick James
04/11/2009 03:27PM
Will a composed index help me?  
4,350
Alex P
04/09/2009 12:36AM
Re: Will a composed index help me?  
2,352
Rick James
04/10/2009 10:31AM
Help with index in a view. Index not used. MySql Bug?  
6,584
Emilio Nicolás
04/01/2009 03:02AM
Re: Help with index in a view. Index not used. MySql Bug?  
3,407
Emilio Nicolás
04/02/2009 02:26AM
Re: Help with index in a view. Index not used. MySql Bug?  
3,377
Emilio Nicolás
04/06/2009 04:20PM
Re: Help with index in a view. Index not used. MySql Bug?  
3,283
Rick James
04/04/2009 10:11PM
Re: Help with index in a view. Index not used. MySql Bug?  
3,206
Emilio Nicolás
04/05/2009 01:08PM
update query optimization  
4,257
rajesh vijayan
04/02/2009 02:17AM
Re: update query optimization  
2,497
Rick James
04/03/2009 06:43PM
Use of DISTINCT in INNER JOIN  
69,649
Steve Croall
03/24/2009 12:07PM
Re: Use of DISTINCT in INNER JOIN  
6,941
Rick James
03/25/2009 07:01PM
Re: Use of DISTINCT in INNER JOIN  
6,642
Steve Croall
03/27/2009 05:20AM
Re: Use of DISTINCT in INNER JOIN  
5,874
Rick James
03/27/2009 10:01AM
Re: Use of DISTINCT in INNER JOIN  
6,828
Steve Croall
03/28/2009 02:02AM
Re: Use of DISTINCT in INNER JOIN  
4,701
Rick James
03/28/2009 03:53PM
Re: Use of DISTINCT in INNER JOIN  
5,908
Steve Croall
04/01/2009 03:36AM
Re: Use of DISTINCT in INNER JOIN  
6,182
Rick James
04/02/2009 12:16AM
Re: Use of DISTINCT in INNER JOIN  
5,655
Steve Croall
04/02/2009 06:29AM
Re: Use of DISTINCT in INNER JOIN  
11,204
Steve Croall
03/24/2009 02:00PM
Query multiple table  
7,063
prem budhu
03/29/2009 05:14PM
Re: Query multiple table  
2,689
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.