db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <Richard.Hille...@Sun.COM>
Subject Re: Converting a value held in a VARCHAR column into an INTEGER
Date Fri, 12 Mar 2010 14:10:31 GMT
Jasvinder S. Bahra wrote:
>> The advantage of this approach is that you can put a useful index on 
>> integerPower and that might speed up your queries.
> This *is* an enormous advantage, but I dont think I want to go down 
> this route because I would potentially have to perform some database 
> maintenance every time I want to insert any records.
Hi Jazz,

I don't think you have to perform any database maintenance at INSERT 
time. The generated column will automatically do the maintenance for you.

Hope this helps,
> I think, for the time being i'm going to try a custom function as per 
> Sylvain's suggestion.  If the speed of the queries is acceptable then 
> i'll stick with that technique.  On the other hand, if the query speed 
> is too slow, then i'll have to revisit *this* technique.
> In any case, thanks again Rick.

View raw message