Timeline for Issue with one query - can some Index help to make it faster?
Current License: CC BY-SA 3.0
16 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)
|
|
| Nov 5, 2016 at 18:45 | comment | added | Dejan | This is the web application and database was created automatically by the installation launchpad..I do not have CREATE TABLE statement | |
| Nov 5, 2016 at 18:18 | comment | added | ypercubeᵀᴹ |
Please don''t just "mention" the plan. Show us the actual execution plan. And show us the actual CREATE TABLE statement.
|
|
| Nov 5, 2016 at 17:23 | history | edited | Dejan | CC BY-SA 3.0 |
added 6 characters in body
|
| Nov 5, 2016 at 17:18 | comment | added | Dejan | Hi WORKORDER is the base table. As I mentioned EXPLAIN QUERY tool returns two TABLESCAN and sort between them | |
| Nov 5, 2016 at 11:43 | comment | added | ypercubeᵀᴹ |
Is the workorder a base table or a view? Can you edit the question and add the CREATE TABLE workorder ..; script and the execution plan of the query?
|
|
| Nov 5, 2016 at 11:33 | answer | added | ypercubeᵀᴹ | timeline score: 1 | |
| Nov 5, 2016 at 5:31 | comment | added | Dejan | Additionally similar issue is on this link please assist me. Thank you!!! dba.stackexchange.com/questions/154338/… | |
| Nov 5, 2016 at 5:31 | comment | added | Dejan | Hi Ian, thank you as always for being so kind to help. I have not yet created index because of is live production system and I cannot stop application until we agree with customer when this will be possible. That is why I want to be sure I should add this index with 3 columns and then to test it, correct? Currently, without this index EXPLAIN query returns TABLESCAN then SORT and then TABLESCAN again. Should I add index with 3 columns? Please confirm because I was not sure because of the ORDER BY columns. As I mentioned this query returns 0 or 1 value. | |
| Nov 4, 2016 at 16:30 | comment | added | Ian Bjorhovde | Have you tried creating indexes and using EXPLAIN to see if DB2 uses them? No answer you're going to get here will substitute for what you get if you explain the query in your actual environment. | |
| Nov 4, 2016 at 7:06 | history | edited | Dejan | CC BY-SA 3.0 |
added 73 characters in body
|
| Nov 4, 2016 at 7:06 | comment | added | Dejan | order by is always fixed it has those two columns so you think those 3 columns in INDEX would help regardless if it has two additional columns in the ORDER BY? | |
| Nov 4, 2016 at 7:04 | comment | added | Dejan | Hi ypercube thanky you for envolvment. It always return one record sorry I forgot to mention that | |
| Nov 4, 2016 at 6:53 | history | edited | ypercubeᵀᴹ | CC BY-SA 3.0 |
added 34 characters in body
|
| Nov 4, 2016 at 6:49 | history | edited | Dejan | CC BY-SA 3.0 |
added 6 characters in body
|
| Nov 4, 2016 at 6:19 | history | asked | Dejan | CC BY-SA 3.0 |