Re: What syntax better (faster,cool)!

sokol_at_opsb.ru wrote:

> select COL into VAR from TABLE;
>
> or
>
> open CURSOR;
> fetch COL into VAR;
> close CURSOR;
>
> Tanks.
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

General advice : Never implement any code difficult to maintain for very small performance advantage.

Syntax 2 is faster, but obviously less easy to maintain if you sure only one row return, so not neccessarily cooler.

Let's ask, what cost is one fetch on TABLE? Received on Fri Dec 11 1998 - 21:54:45 CST