prepared vs unprepared
843854Jan 11 2002 — edited Jan 16 2002Where I am located executing sql statements takes considerable amout of time. So I am trying to avoid any delay at all cost.
For tatements that are used only once, how are the tradeoffs between prepared and not-prepared statements? I am using Oracle 9i and both windows & linux.
And is there a way to use a sequence to set a placeholder without doing a separate select statement?