| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: reading random records with JDBC?
> With the Primary Key, you searches will be MUCH faster. This is the
> direction I clumsily tried to lead you toward.
Yes, but this is very complicated. The primary key can consist of 20 different columns so the program has to fiddle that out and build the where clause with all the primary key columns. And while comparing, the primary key columns should not be compared.
JMS Received on Wed Nov 28 2007 - 09:12:02 CST
 |
 |