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 performance
Search options not deleted
user 50242
Performance is a subset of Optimization: performance is the goal when you want the execution time of your program or routine to be optimal.
4
votes
Accepted
Finding the runtime of a task by name
With a query this simple, it's going to be hard to make any major improvements.
Firstly, you should use INNER JOIN as opposed to JOIN it makes the query much easier to understand at a glance.
I wo …
- 1,321
2
votes
Accepted
Select Queries From Parent-Child Tables Model
Checking runtimes
I found this stackoverflow question had some good answers regarding comparing SQL runtimes/performance. …
- 1,321
1
vote
Extract last record inserted for each key identifier
Allow me to suggest using the ROW_NUMBER function, which allows you to number returned rows using the ordering you provide.
Here is a complete query that uses the ROW_NUMBER function. I also removed …
- 1,321
6
votes
Accepted
For a query over multiple databases, is it faster to do GROUP BY first or UNION first?
The Second is Faster
Having just tested a slightly simpler version of this, using only 1 column to be aggregated, I found that the second version is faster. I would also argue that the second is mu …
- 1,321