On 11/27/14 3:56 AM, kosurusekhar wrote:
Hi folks,
We decided to create a table column with User Defined Type (A java class has
big byte array& certain other properties), Is there any issues or any
problems (performance side) while doing insert / update / delete into or
from this table?
If any body come across this kind of scenario means please suggest me with
your inputs.
Regards
Sekhar.
Hi Sekhar,
I don't know of any INSERT/UPDATE/DELETE performance problems. However,
UDTs are not indexable by themselves, which may give you performance
problems when you SELECT them. One workaround is to add a generated
column to extract an indexable key out of the UDT.
Hope this helps,
-Rick
--
View this message in context:
http://apache-database.10148.n7.nabble.com/User-Defined-Type-as-Table-Column-tp143321.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.