Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with query-performance
Search options not deleted
user 28990
For questions about improving the performance and/or efficiency of database queries.
0
votes
How to improve performance of a query with an IN subquery
SELECT COUNT(UserID) as CountUsers
FROM
(SELECT
A.user_id as UserIDs,
A.order_id as XTag,
B.order_id as YTag
FROM MyCustomTable A
INNER JOIN MyCustomTable B
ON A.User_ID = B.Use …
- 312
1
vote
MySQL: Why is this UPDATE query so incredibly slow?
Why don't you just build a temp table and use the results to update. This is bad form. It's got to build the Subquery first, then assemble that in the WHERE Clause, then it's going to update every rec …
- 312