Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: BobWhitefield
- Order by date
-
Are null CHAR() columns compressed in any way?
Just as I hoped. Thanks sem!- BobWhitefield
- Post #3
- Forum: Oracle: Enterprise Developer Suite
-
Are null CHAR() columns compressed in any way?
In Oracle 8 or later, if I declare a column as CHAR(20), and have 100K rows where this column is null, is this actually using two megs of storage, or does Oracle employ some kind of compression mechanism? Thanks! Bob- BobWhitefield
- Thread
- Replies: 2
- Forum: Oracle: Enterprise Developer Suite
-
Normalization Question? Have I gone too far......
I don't think it's going too far to have a separate address table. Yes, you will pay a small performance penalty doing a join. The advantage is decoupling your other tables from the details of addresses. In addition to companies, do you have tables for employees, divisions, etc. that have...- BobWhitefield
- Post #3
- Forum: -General database discussion
-
How to create a VIEW from metadata definition?
Say I have these four tables: Product productKey productTypeKey quantityOnHand ProductType productTypeKey name ProductAttribute productAttributeKey name valueType -- 1=boolean, 2= float, etc. productTypeKey ProductAttributeValue valueBoolean NUMBER(1) valueFloat FLOAT...- BobWhitefield
- Thread
- Replies: 0
- Forum: -General database discussion
