Stories
Slash Boxes
Comments

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

use Perl

All the Perl that's Practical to Extract and Report

When NOT to use placeholders More | Login | Reply

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.

Without JavaScript enabled, you might want to use the classic discussion system instead. If you login, you can remember this preference.

Re: When NOT to use placeholders (Score:2)

by dws (341)

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.
- Re: When NOT to use placeholders (Score:2)
  
  by djberg96 (2603)
  
  Oracle has some knob you can twist to get better behavior, but it's buried in the docs
  There's probably a hint you can use. While I think hints are both nice and powerful, there is simply no way your average developer is going to remember them all. At least, I doubt that I ever will.

Get More Comments

Stories, comments, journals, and other submissions on use Perl; are Copyright 1998-2006, their respective owners.