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,270
Dmitriy Gorbenko
07/21/2009 11:37AM
Re: Why so great difference in so simple query ?  
2,046
Rick James
08/23/2009 06:57PM
sql trace  
3,216
Wilchard Oomens
08/07/2009 12:58AM
Re: sql trace  
2,120
Rick James
08/23/2009 06:48PM
Simplify optimization with distinct names  
3,316
Chris Hennick
08/19/2009 11:10AM
Re: Simplify optimization with distinct names  
2,147
Rick James
08/20/2009 09:05PM
MYSQL optimizer: Handling Subqueires  
3,228
Rakshit Trivedi
08/17/2009 05:50AM
Re: MYSQL optimizer: Handling Subqueires  
2,027
Rick James
08/18/2009 06:38PM
Re: MYSQL optimizer: Handling Subqueires  
2,091
Rakshit Trivedi
08/19/2009 03:33AM
Re: MYSQL optimizer: Handling Subqueires  
2,002
Rick James
08/19/2009 09:01PM
Re: MYSQL optimizer: Handling Subqueires  
1,989
Rakshit Trivedi
08/20/2009 09:34AM
Re: MYSQL optimizer: Handling Subqueires  
2,040
Rick James
08/20/2009 10:33AM
How to check table is successfully optimize?  
2,722
Syed Nabeel Anwer
08/19/2009 12:47AM
Re: How to check table is successfully optimize?  
2,296
Rick James
08/20/2009 10:20AM
Performance for bind variables & Tuning  
2,936
krunal pala
08/14/2009 03:19AM
Re: Performance for bind variables & Tuning  
2,651
Rick James
08/15/2009 02:49PM
Re: Performance for bind variables & Tuning  
2,182
krunal pala
08/17/2009 06:20AM
Re: Performance for bind variables & Tuning  
3,099
Rick James
08/17/2009 09:48AM
add a correct index, the same select statement becomes 5 times slower  
3,807
qiu cheng
05/27/2009 07:51PM
Re: add a correct index, the same select statement becomes 5 times slower  
2,114
shahbaz khan
08/16/2009 11:47AM
Re: add a correct index, the same select statement becomes 5 times slower  
2,168
Rick James
08/16/2009 03:54PM
Help optimizing dependant subqueries.  
2,904
Rob Hofmeyr
08/13/2009 01:43PM
Re: Help optimizing dependant subqueries.  
1,807
Rick James
08/15/2009 04:15PM
Three(or Four)-Way Joins  
3,691
Malcolm Wardlaw
08/11/2009 07:10PM
Re: Three(or Four)-Way Joins  
2,092
Rick James
08/12/2009 08:35PM
Re: Three(or Four)-Way Joins  
1,838
Malcolm Wardlaw
08/12/2009 09:31PM
Re: Three(or Four)-Way Joins  
1,942
Rick James
08/13/2009 12:16AM
Re: Three(or Four)-Way Joins  
1,920
Malcolm Wardlaw
08/13/2009 12:26PM
Re: Three(or Four)-Way Joins  
2,617
Rick James
08/13/2009 10:34PM
Create index for period of time  
3,327
Frank Schuster
07/28/2009 12:17AM
Re: Create index for period of time  
2,362
Rick James
08/08/2009 09:08PM
How to speed up the building of huge (>15 mln entries) normalized database?  
2,859
Kateryna Tymoshenko
07/27/2009 05:21AM
Re: How to speed up the building of huge (>15 mln entries) normalized database?  
1,768
Rick James
08/08/2009 08:59PM
How can I get the 'EXISTS' or 'IN' use an index?  
3,086
Johannes Fosseus
07/30/2009 04:39AM
Re: How can I get the 'EXISTS' or 'IN' use an index?  
1,903
Rick James
08/08/2009 04:44PM
JOINS AND INDEX NOT USED  
3,410
Steve Gore
07/30/2009 04:51PM
Re: JOINS AND INDEX NOT USED  
1,841
Rick James
08/07/2009 10:45PM
Simple query not using index  
4,356
Matthew Conway
08/05/2009 09:30AM
Re: Simple query not using index  
2,058
Matthew Conway
08/07/2009 04:15PM
Re: Simple query not using index  
2,306
Matthew Conway
08/07/2009 02:54PM
Using indexes with IN statement  
3,536
Dmitriy Gorbenko
07/21/2009 11:06AM
One Primary Key vs. Two  
3,069
Malcolm Wardlaw
07/19/2009 11:40AM
Query using "ref" instead of "range" access  
4,301
Keldon Jones
07/09/2009 04:52PM
Re: Query using "ref" instead of "range" access  
1,987
Rick James
07/11/2009 09:57PM
Re: Query using "ref" instead of "range" access  
2,214
Keldon Jones
07/11/2009 10:59PM
Re: Query using "ref" instead of "range" access  
2,131
Rick James
07/12/2009 09:32AM
Re: Query using "ref" instead of "range" access  
2,028
Keldon Jones
07/14/2009 04:37PM
How to select best keyword for optimization ?  
3,316
milly dou
07/07/2009 02:18AM
optimize mysql query  
4,216
andy susanto
06/27/2009 07:13PM
Optimizing Multiple ORDER BYs  
11,378
Sep Si
06/25/2009 07:50PM
Re: Optimizing Multiple ORDER BYs  
3,583
Rick James
06/27/2009 12:28AM
Query Optimization  
4,052
Nils Heldt
06/22/2009 03:46AM
Re: Query Optimization  
2,234
Rick James
06/23/2009 09:12AM
Re: Query Optimization  
2,191
Nils Heldt
06/24/2009 06:09AM
Query Optimization  
4,061
Praveen Kumar
06/15/2009 06:07AM
Re: Query Optimization  
2,258
Jani Patokallio
06/16/2009 03:43AM
Re: Query Optimization  
2,091
Rick James
06/16/2009 10:40PM
Top 10 airports referenced from a table of flights  
5,028
Jani Patokallio
06/09/2009 12:40AM
Re: Top 10 airports referenced from a table of flights  
2,169
Rick James
06/11/2009 10:46PM
Re: Top 10 airports referenced from a table of flights  
2,213
Rick James
06/11/2009 10:48PM
Re: Top 10 airports referenced from a table of flights  
2,331
Jani Patokallio
06/15/2009 10:16AM
Re: Top 10 airports referenced from a table of flights  
2,197
Rick James
06/15/2009 10:23PM
Re: Top 10 airports referenced from a table of flights  
3,253
Jani Patokallio
06/16/2009 03:35AM
multiple range query, using temporally and filesort  
3,920
Beer Bud
06/06/2009 10:44PM
Re: multiple range query, using temporally and filesort  
2,249
Rick James
06/08/2009 12:12AM
Query Optimization Help  
3,069
William Graham
06/04/2009 11:37AM
Re: Query Optimization Help  
2,108
Rick James
06/05/2009 08:37PM
Get rid of Temporary/filesort, rather simple query  
6,065
Reine n/a
06/01/2009 03:07AM
Re: Get rid of Temporary/filesort, rather simple query  
2,953
Rick James
06/02/2009 07:48PM
Re: Get rid of Temporary/filesort, rather simple query  
3,042
Reine n/a
06/03/2009 12:58AM
Re: Get rid of Temporary/filesort, rather simple query  
2,640
Rick James
06/03/2009 10:52PM
Re: Get rid of Temporary/filesort, rather simple query  
2,661
Reine n/a
06/04/2009 01:07AM
Re: Get rid of Temporary/filesort, rather simple query  
3,088
Rick James
06/04/2009 09:03AM
Re: Get rid of Temporary/filesort, rather simple query  
2,646
Reine n/a
06/04/2009 03:06PM
Re: Get rid of Temporary/filesort, rather simple query  
2,648
Rick James
06/04/2009 07:39PM
EXPLAIN Table reference order  
4,762
Sunil H
05/27/2009 01:06AM
Re: EXPLAIN Table reference order  
2,274
Rick James
05/28/2009 07:10PM
Table reordering of multi-table DELETE  
4,009
Saverio Miroddi
05/26/2009 03:43PM
Re: Table reordering of multi-table DELETE  
2,597
Rick James
05/27/2009 01:21AM
Re: Table reordering of multi-table DELETE  
2,284
Saverio Miroddi
05/27/2009 02:11AM
Re: Table reordering of multi-table DELETE  
2,266
Rick James
05/27/2009 09:52AM
Re: Table reordering of multi-table DELETE  
2,309
Saverio Miroddi
05/28/2009 07:10AM
Fast LIKE search  
15,214
andrew browne
05/23/2009 10:09AM
Re: Fast LIKE search  
6,798
Rick James
05/24/2009 12:41PM
Re: Fast LIKE search  
4,287
andrew browne
05/25/2009 12:58PM
Re: Fast LIKE search  
5,425
andrew browne
05/25/2009 10:27AM
Parallel scans  
3,751
Steve Fink
05/19/2009 04:15PM
Re: Parallel scans  
2,148
Rick James
05/20/2009 10:39PM
Nevermind. I'll program around it.  
2,982
Mark Marshall
05/18/2009 01:47PM
Re: Nevermind. I'll program around it.  
2,108
Rick James
05/19/2009 11:36PM
Need help :-(  
2,965
Shane Zammit
05/18/2009 04:36PM
Re: Need help :-(  
2,165
Rick James
05/19/2009 11:24PM
Query speed and columns per table  
3,787
Malcolm Wardlaw
05/18/2009 04:43PM
Re: Query speed and columns per table  
2,199
Rick James
05/19/2009 08:39PM
How to make this query faster? UNION + Inner Join  
10,437
Robin Bartholdson
02/21/2007 05:23AM
Re: How to make this query faster? UNION + Inner Join  
3,550
thina karan
05/16/2009 08:47AM
Re: How to make this query faster? UNION + Inner Join  
4,083
Rick James
05/16/2009 11:02PM
Simple queries hang on "statistics"  
4,705
Jay Paroline
05/01/2009 12:26PM
Re: Simple queries hang on "statistics"  
2,330
Jay Paroline
05/08/2009 03:12PM
Re: Simple queries hang on "statistics"  
2,497
Rick James
05/08/2009 09:00PM
Re: Simple queries hang on "statistics"  
2,477
Jay Paroline
05/12/2009 08:49AM
Re: Simple queries hang on "statistics"  
2,428
Rick James
05/01/2009 11:00PM
How to set limit to log & data files? - while running snort ids  
3,272
Anton A
04/27/2009 12:10PM
Re: How to set limit to log & data files? - while running snort ids  
2,418
Rick James
05/02/2009 12:51PM
Re: How to set limit to log & data files? - while running snort ids  
2,482
Anton A
05/07/2009 01:25AM
Re: How to set limit to log & data files? - while running snort ids  
2,307
Rick James
05/07/2009 07:22PM
Re: How to set limit to log & data files? - while running snort ids  
2,621
Anton A
05/07/2009 08:47PM
Re: How to set limit to log & data files? - while running snort ids  
2,288
Rick James
05/07/2009 11:56PM
The New MySQL Query Profiler and previous versions of MySQL  
3,550
Nikolas Branis
05/06/2009 03:41AM
Query taking a lot of time if there is no record in table  
5,437
Aditi mittal
04/29/2009 04:42AM
Re: Query taking a lot of time if there is no record in table  
2,408
Rick James
04/30/2009 11:31PM
Re: Query taking a lot of time if there is no record in table  
2,376
Aditi mittal
05/04/2009 01:30AM
Re: Query taking a lot of time if there is no record in table  
2,289
Rick James
05/04/2009 07:19PM
Re: Query taking a lot of time if there is no record in table  
2,356
Aditi mittal
05/04/2009 11:46PM
3 Table Join (indexed) results in where-temp-filesort  
4,991
Doug Crane
04/30/2009 08:21PM
Re: 3 Table Join (indexed) results in where-temp-filesort  
2,601
Rick James
05/03/2009 04:19PM
Re: 3 Table Join (indexed) results in where-temp-filesort  
2,381
Doug Crane
05/01/2009 07:22PM
Extremely large tables  
4,105
Malcolm Wardlaw
04/27/2009 09:30PM
Re: Extremely large tables  
2,285
Rick James
04/28/2009 11:01PM
Re: Extremely large tables  
2,428
Malcolm Wardlaw
05/01/2009 01:28PM
does unique index do more than just being a constraint?  
8,206
Martijn Groen
04/24/2009 08:29PM
Re: does unique index do more than just being a constraint?  
4,870
Rick James
04/25/2009 09:11PM
Error message when trying to optimize tables  
3,267
Keith Duncan
04/21/2009 01:04PM
Index not being used  
6,471
Patrick O'Loughlin
04/14/2009 05:18AM
Re: Index not being used  
3,228
Rick James
04/15/2009 10:41AM
Re: Index not being used  
3,008
Patrick O'Loughlin
04/21/2009 02:55AM
Unexpected join optimization  
3,539
Grace Zhu
04/17/2009 01:21PM
Re: Unexpected join optimization  
2,242
Grace Zhu
04/17/2009 02:36PM
LOW_PRIORIY, IGNORE, DELAY & QUICK  
3,162
sandeep gupta
04/09/2009 04:06AM
Re: LOW_PRIORIY, IGNORE, DELAY & QUICK  
2,502
Rick James
04/11/2009 03:27PM
Will a composed index help me?  
4,191
Alex P
04/09/2009 12:36AM
Re: Will a composed index help me?  
2,271
Rick James
04/10/2009 10:31AM
Help with index in a view. Index not used. MySql Bug?  
6,300
Emilio Nicolás
04/01/2009 03:02AM
Re: Help with index in a view. Index not used. MySql Bug?  
3,313
Emilio Nicolás
04/02/2009 02:26AM
Re: Help with index in a view. Index not used. MySql Bug?  
3,299
Emilio Nicolás
04/06/2009 04:20PM
Re: Help with index in a view. Index not used. MySql Bug?  
3,219
Rick James
04/04/2009 10:11PM
Re: Help with index in a view. Index not used. MySql Bug?  
3,112
Emilio Nicolás
04/05/2009 01:08PM
update query optimization  
4,116
rajesh vijayan
04/02/2009 02:17AM
Re: update query optimization  
2,411
Rick James
04/03/2009 06:43PM
Use of DISTINCT in INNER JOIN  
68,541
Steve Croall
03/24/2009 12:07PM
Re: Use of DISTINCT in INNER JOIN  
6,832
Rick James
03/25/2009 07:01PM
Re: Use of DISTINCT in INNER JOIN  
6,529
Steve Croall
03/27/2009 05:20AM
Re: Use of DISTINCT in INNER JOIN  
5,759
Rick James
03/27/2009 10:01AM
Re: Use of DISTINCT in INNER JOIN  
6,701
Steve Croall
03/28/2009 02:02AM
Re: Use of DISTINCT in INNER JOIN  
4,596
Rick James
03/28/2009 03:53PM
Re: Use of DISTINCT in INNER JOIN  
5,788
Steve Croall
04/01/2009 03:36AM
Re: Use of DISTINCT in INNER JOIN  
6,068
Rick James
04/02/2009 12:16AM
Re: Use of DISTINCT in INNER JOIN  
5,537
Steve Croall
04/02/2009 06:29AM
Re: Use of DISTINCT in INNER JOIN  
11,057
Steve Croall
03/24/2009 02:00PM
Query multiple table  
6,868
prem budhu
03/29/2009 05:14PM
Re: Query multiple table  
2,621
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.