Timeline for Performance impact of including result column in indexed columns
Current License: CC BY-SA 3.0
13 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 7, 2020 at 22:23 | history | edited | CommunityBot |
added [query-performance] to 2412 questions - Shog9 (Id=1924)
|
|
| Aug 10, 2017 at 3:04 | history | edited | RolandoMySQLDBA |
edited tags
|
|
| Jan 1, 2013 at 7:03 | history | tweeted | twitter.com/#!/StackDBAs/status/286004589050884097 | ||
| Jan 1, 2013 at 3:26 | history | edited | nanofarad | CC BY-SA 3.0 |
added 14 characters in body
|
| Jan 1, 2013 at 3:25 | vote | accept | nanofarad | ||
| Jan 1, 2013 at 2:39 | comment | added | RolandoMySQLDBA | I added an answer. Hope it helps !!! | |
| Jan 1, 2013 at 2:38 | answer | added | RolandoMySQLDBA | timeline score: 4 | |
| Jan 1, 2013 at 2:17 | comment | added | RolandoMySQLDBA |
Yes. When I see a query, the WHERE, GROUP BY and ORDER BY clauses usually give clues as to what indexes to create.
|
|
| Jan 1, 2013 at 2:05 | comment | added | nanofarad | @RolandoMySQLDBA I'm still in the design phase on paper, unfortunately, since there are many other factors outside database design that need to go into the finished product. I'll try to add any info that I can. Was it too early to ask without this info? | |
| Jan 1, 2013 at 2:04 | history | edited | nanofarad | CC BY-SA 3.0 |
added 14 characters in body
|
| Jan 1, 2013 at 1:59 | comment | added | RolandoMySQLDBA | Please tell us if the table is MyISAM or InnoDB. | |
| Jan 1, 2013 at 1:58 | comment | added | RolandoMySQLDBA |
Please post sample queries you use to retrieve texels. Also, please run SHOW CREATE TABLE texeltblname\G and show its result.
|
|
| Jan 1, 2013 at 1:36 | history | asked | nanofarad | CC BY-SA 3.0 |