|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
August 31st, 2005, 10:17 AM
|
|||
|
|||
Optimzing Oracle table format
In MySQL, there is a significant performance gain when tables only contain fields with a fixed length - no varchars, for example. Now my question is: is that the same with Oracle? Is it worth the effort to eliminate all varchar fields from an Oracle table with lots of rows and move them to another table, or doesn't that have any effect with Oracle tables?
|
|
#2
August 31st, 2005, 02:14 PM
|
|||
|
|||
|
No, not in Oracle. In fact using all CHAR fields will just use up a lot of disk space.
|
|
| Viewing: Dev Shed Forums > Databases > Oracle Development > Optimzing Oracle table format |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
