Timeline for Oracle function based index is not used in query
Current License: CC BY-SA 3.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 31, 2012 at 12:08 | comment | added | Leigh Riffel | Nice followup work. As you have already discovered, your modification will allow it to avoid having to look at the table at all as it can get everything it needs from the index. | |
| Jul 30, 2012 at 20:39 | vote | accept | a1ex07 | ||
| Jul 30, 2012 at 20:39 | comment | added | a1ex07 |
Finally I made it fast full scan , SELECT COUNT(WHEN col1 = 3 THEN val1 ELSE NULL END) WHERE CASE WHEN col1 = 3 THEN val1 ELSE NULL END IS NOT NULL;. Thank you again for hint.
|
|
| Jul 30, 2012 at 19:37 | comment | added | a1ex07 |
Thanks, but it still doesn't work exactly as you say : COUNT(val1) - still full scan, but count(*) index fast full scan... select val1... also ends up with full scan...
|
|
| Jul 30, 2012 at 19:36 | history | edited | Leigh Riffel | CC BY-SA 3.0 |
added 11 characters in body
|
| Jul 30, 2012 at 19:30 | history | answered | Leigh Riffel | CC BY-SA 3.0 |