Re: If select using rownum savs time?

Originally posted by Music4
> I have table that contains a huge number of records (over
> 100000). And I
> need to select first 5000 records. In my current application, I
> just use
> "select * from the_table", then only petch first 5000 records.
>
> And today, I happened to get know "rownum", so I am guess if
> "select * from
> the_table where rownum < 5000" would be efficient. Is that true?
>

Comes to the same thing, but ROWNUM version is easier to code. Either way, you get "first" 5000 rows from table and then stop fetching rows, so performance should be the same.

--
Posted via http://dbforums.com