Timeline for Why does the function TO_CHAR get invoked for each row when not wrapped in a subquery?
Current License: CC BY-SA 4.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 23, 2022 at 20:44 | history | edited | mustaccio | CC BY-SA 4.0 |
I edited the title to better reflect what's being asked.
|
| Dec 23, 2022 at 20:03 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Oct 4, 2021 at 21:36 | comment | added | JAEGEUN YU | In Oracle the table id modeled to store a data value in varchar columns. We have decided not to change the type of the column. In Oracle we don't have an index on the column either. | |
| Oct 4, 2021 at 20:32 | answer | added | Laurenz Albe | timeline score: 1 | |
| Oct 4, 2021 at 15:20 | comment | added | user1822 |
Why are you storing date values in varchar columns to begin with? That's a really bad idea. Do you have a chance to fix that broken data model?
|
|
| Oct 4, 2021 at 15:15 | comment | added | jjanes | If you had a sensible index, the first one would be so fast you would have trouble measuring it reliably. Who knows, maybe in Oracle you do have sensible index. | |
| Oct 4, 2021 at 13:59 | history | asked | JAEGEUN YU | CC BY-SA 4.0 |