On 2018-04-04 16:53, Fernando D. Bozzo wrote:
Not counting legacy reasons for already available systems, I think that this is because many did not learn about the available data types and just stay with what they know, others because did think that are the same, and others because they don't care.
I know some of those guys, btw.
ALBEIT PROBABLY MINISCULE, won't the Integer type be a better, more efficient, faster processing choice? I noticed in this app I inherited, the main table where it's the PK, it's an INTEGER type, but in a another table where it's the foreign key, it's a N(10,0) type. I'll have to break out SYS(3054) I guess to see if it optimizes, given the difference!