Slash Boxes
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
More | Login | Reply
Loading... please wait.
  • Using placeholders in LIKE clauses is problematic. RDMBSs that prepare queries usually build the execution plan at prepare time. But without knowing what the LIKE clause looks like (e.g., 'foo%' vs. '%foo'), the query planner has to assume worst-case, which means a full table scan. Oracle has some knob you can twist to get better behavior, but it's buried in the docs.