Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: anandsatchin
- Content: Threads
- Order by date
-
query optimization
Hi... I need to exectue all the 6 queries in a sequential order which are stored in stored procedure. I am just wondering is there any way to make general into one query with CASE statements or any other better statement I can use. Cheers DB: MySql 5.0 Table Name: sorting_temp Column...- anandsatchin
- Thread
- Replies: 3
- Forum: MySQL
-
Mysql Query performance
Hello, wondering whether anyone could shed light on my problem.. Basically, I need to exectute a query, when I execute the first query (with left join), it takes nearlly 4 mins 29.88 sec and the same query (with right join), it takes nearlly 0.22 sec. I know I might be wrong somewhere..can...- anandsatchin
- Thread
- Replies: 2
- Forum: MySQL
