I have a vague memory of being wary of using too many TEXT datatype columns in an individual table, but I can't seem to find any specific information about it. I think it was an issue with Oracle at some point, but my memory is hazy. Is there anything I should be concerned about if a single table has multiple TEXT columns defined? If so, how many is too many?
I'm defining a table with 6 TEXT columns and a few other VARCHAR columns and I want to make sure that it won't be an issue before I do it. It's a table that should see a lot of traffic, and if moving those fields to another table would help, I'll do that. I'm using 9i. Thanks!
I'm defining a table with 6 TEXT columns and a few other VARCHAR columns and I want to make sure that it won't be an issue before I do it. It's a table that should see a lot of traffic, and if moving those fields to another table would help, I'll do that. I'm using 9i. Thanks!
