On converting raw tables into standard ones
Posted in 2008
=?iso-8859-1?Q?Omar_Mu=F1oz?= — — source: Usenet: comp.databases.informix
Hi. I have to reorganize a fragmented very big table (31 M rows). In order to keep users connected as long as I can, I was thinking about creating a parallel well-configurated table as a raw one in order to load data faster and with minimal damage to performance, so when it finishes, I would be able to change from raw to standard, restrict access only for index creation and finally drop old table and rename new one. My doubt is: should I consider any other thing besides making a level-0 backup to transform a raw table into a standard one? My plattform is Solaris 9 and IDS 9.40 FC7. Thanks in advance. Omar Muñoz.