My office is changing all our logic to use “objects” in PL/SQL that reference a database table. I NEED to understand this from the base.
I've noticed severe performance issues if I query using the object function vs querying the table directly. EX: 5-6 minutes vs. 30-40 seconds.
A colleague suggested “pipelines” but all I have is an example to follow. I'd like to actually understand what's going on.
Can anyone recommend a good book or tutorial etc?