sql - Performance related questions regarding Oracle Arrays (Collection) -

To be able to implement the query

  "select from table1 * id [ A set of elements] " 

I am using the oracle array. I like the display very well. Let's say that IID is an intersection, then I will create an array type:

  make type number_worrah as the varray ([size]);  

Then I can select a prepared statement

  from the table 1 where in the id (select (* from the table))  

Setting the parameter to an array type. I have a few questions:

1. If I make the size too big, does a performance hit if the number of elements in the query is small?
2. What is the size limit?
3. When I call conn.createOracleArray (string name, OBJ [] elements) does it kill the server or does it after performing a query?
4. Is there a more effective way of implementing such queries in Oracle? This is more than one question, but I will try it:

P>

1. If you look at answer 4, then the performance will not really be bad
2. According to the limit is 65536, but I believe if you exceeded this number So you do something wrong
3. It is in my opinion that the Oracle is not connected to the array ...

4. using the member's Do it, in a more efficient way:

     select * from table 1 where my_number_varray's ID member;