Re: Speed of data retrival

[Quoted] [Quoted] "Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message news:3CF3A073.9957EFE2_at_exesolutions.com...
> Stjepan Brbot wrote:
>
> > What is the difference according to speed of data retrival or any other
> > aspect of execution speed if one uses more columns in SELECT
> > SQL-statement?
> >
> > Is there any difference in retrival of these two SELECT statements:
> >
> > SELECT col1,col2,col3 FROM table1 WHERE col1=4
> >
> > and
> >
> > SELECT col1,col2 FROM table1 WHERE col1=4
> >
> > --
> >
> > Stjepan Brbot
>
> Immeasureably small.

[Quoted] In general but it depends on the data

[Quoted] select title,date from films where director = 'HITCHCOCK';

[Quoted]  will be considerably faster than

[Quoted] select title,date,video_content from films where director = 'HITCHCOCK';

--
Niall Litchfield
[Quoted] Oracle DBA
Audit Commission UK