God Oracle is unpredictable with query plans. It's not helped that whoever built this database completely ignored keys, clustering, etc that would make what I'm trying to do trivial
Or, you know, not f-ing up the data to begin with
"Here, let me clobber all these strings together so you can seek on an index" Oracle: "How about I sort everything instead?" "Ok, how about I use SUBSTR?" Oracle: No need to sort boss, I got this!
This isn't really an oracle thing as much as it's a bad database thing and trying to trick oracle around it