Consider a Table with Primary Key as columnd "id"

It has to be queried for a range of id as [ 1, 2, 3, 4 ...]

There are 2 option - 

1) 

```
Select * from Table where id = 1;
Select * from Table where id = 2;
Select * from Table where id = 3;
Select * from Table where id = 4;

```

2) 

```
Select * from Table where id in ( 1, 2, 3, 4 );

```

Which of the two is better in performance for Oracle as Databse and using Spring JDBC Template for persistence. Leave aside memory constraint from application point of view assuming that dataset 1, 2, 3, 4 will be within limit for java data structures. 

It uses database connection pooling.