йенс мартин шлаттер wrote:
>>From a huge table, I want to read random records via JDBC to make some
> statistic things. How do I best and fastest afford this?
> Just like this: "select * from ... where rowid=?" or are there better
> ways?
>
> JMS
Use the SAMPLE clause
http://www.psoug.org/library.html
scroll down to "SAMPLE CLAUSE."
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Sun Nov 04 2007 - 13:37:45 CST
