Timeline for Speeding up COUNT(*) - WHERE clause slowing query
Current License: CC BY-SA 3.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 15, 2012 at 12:47 | comment | added | Chris Aldrich | You might also not want to pass everything to the count function. Depending on the database that may not be optimal. It may grab everything, then count it. It might be easier to do just a count(message_type_id). Should give you the same result, but helps the engine to cut off extra rows it doesn't need to care about. | |
| Aug 14, 2012 at 7:43 | answer | added | gbn | timeline score: 6 | |
| Aug 13, 2012 at 17:53 | history | tweeted | twitter.com/#!/StackDBAs/status/235071489102213121 | ||
| Aug 13, 2012 at 17:11 | comment | added | JNK | Is this related to your other question that you recently opened? | |
| Aug 13, 2012 at 16:53 | answer | added | Jon Seigel | timeline score: 4 | |
| Aug 13, 2012 at 16:50 | answer | added | Aaron Bertrand | timeline score: 3 | |
| Aug 13, 2012 at 16:41 | answer | added | A-K | timeline score: 4 | |
| Aug 13, 2012 at 16:38 | history | asked | Darthtong | CC BY-SA 3.0 |