Re: Column placement and performance
From: DavidJRoth <davidjroth_at_aol.com>
Date: 12 Jan 1995 21:15:11 -0500
Message-ID: <3f4nnf$sac_at_newsbf02.news.aol.com>
Date: 12 Jan 1995 21:15:11 -0500
Message-ID: <3f4nnf$sac_at_newsbf02.news.aol.com>
>Subject: Column placement and performance
>From: 68a869_at_llnl.gov (Jeff Busch)
>Date: 12 Jan 1995 20:27:57 GMT
>Message-ID: <3f43cd$kn1_at_lll-winken.llnl.gov>
>When creating tables in Oracle 7, is there a performance advantage to
>creating the columns in a particular order?
>---
>Jeff Busch Internet busch1_at_llnl.gov
>Voice (510) 423-9134 Fax (408) 263-1360
Yes. But the most frequently access columns first. Also, but columns that are most likley to be null last. This will save space.
David Roth
CMC Systems
508-392-1300
Received on Fri Jan 13 1995 - 03:15:11 CET