Home » Developer & Programmer » Designer » Unused column in a table
Unused column in a table [message #90484] Thu, 27 November 2003 08:29 Go to next message
Pushparaj
Messages: 4
Registered: May 2002
Junior Member
Does an unused column in a database table cause any overhead in terms of storage space.
By unused column I mean a column which is of a datatype number but will not contain any value ie null.
Re: Unused column in a table [message #90486 is a reply to message #90484] Fri, 28 November 2003 16:41 Go to previous messageGo to next message
Chadders
Messages: 18
Registered: November 2003
Junior Member
Depends on it's position in the table and whether any subsequent columns contain data, but basically, if a column is NULL, it either "takes up" 1 or 0 bytes, i.e. 1 byte if the NULL column is "in the middle" of two non-NULL columns, otherwise, it's 0, i.e. at the "end" of the table.
Re: Unused column in a table (Oracle) [message #90560 is a reply to message #90484] Thu, 04 March 2004 23:21 Go to previous messageGo to next message
Anup Chaurasia
Messages: 1
Registered: March 2004
Junior Member
How we can make unused column as used columns ?
Re: Unused column in a table [message #90721 is a reply to message #90484] Fri, 10 September 2004 05:08 Go to previous message
Vijay
Messages: 116
Registered: September 1999
Senior Member
hello i want to know unused column to used column how can u send script ok bye
Previous Topic: DB Creation PBs
Next Topic: How to test oracle sqlldr
Goto Forum:
  


Current Time: Thu Oct 30 14:11:59 CDT 2014

Total time taken to generate the page: 0.07247 seconds