Re: Trun Off Indexes!
Hi, You are absolutely right. The point that once lots of data have been added into the tables the indexes are out dated any way (even if they are turned off and on. I have come to realize that you can turn on and off Indexes with Informix Dynamic Server). Some how the bell did'nt ring in my head. Without doubt now , I will delete and recreate my Indexes. Thank you for the enlightenment. sherwin Sebastian Paul Avarvarei wrote: > Hi! > > I can't think of any method of temporarily turning off the indexes (but > I'm not very experienced). > > But I can't find any reasons for doing so. Even you could stop and restart > the indexes, after restart they would have to be recreated for the new lines > anyway. > > On the other hand, if you don't have frequent inserts/updates, just big > load jobs from time to time, dropping and recreating the indexes would > allow you to create better indexes, with a big fillfactor. Maybe it would > be a good idea to post the exact situation you have (the size of the tables, > the size of the data to be loaded, the type of environment and so on.) > > Regards, > Sebastian Paul A. > E-mail: proteus@romus.com > > Sherwin (28.05.1999 14:56): > >Can all indexes on a table in an Informix Database be turned off and > >then turned on again later. I need to speed up loading of data into my > >tables. But I don't wana drop and recreate my indexes, neither do I want > >them slowing down my data insertion. > > > >sherwin > > > > > >
But which is faster, enable / disable or drop / recreate? I've always dropped and recreated, myself. John Carlson Informix DBA WHSmith USA sherwin wrote: > > Hi, > You are absolutely right. The point that once lots of data have been added > into the tables the indexes are out dated any way (even if they are turned off > and on. I have come to realize that you can turn on and off Indexes with > Informix Dynamic Server). Some how the bell did'nt ring in my head. Without > doubt now , I will delete and recreate my Indexes. Thank you for the > enlightenment. > > sherwin > > Sebastian Paul Avarvarei wrote: > > > Hi! > > > > I can't think of any method of temporarily turning off the indexes (but > > I'm not very experienced). > > > > But I can't find any reasons for doing so. Even you could stop and restart > > the indexes, after restart they would have to be recreated for the new lines > > anyway. > > > > On the other hand, if you don't have frequent inserts/updates, just big > > load jobs from time to time, dropping and recreating the indexes would > > allow you to create better indexes, with a big fillfactor. Maybe it would > > be a good idea to post the exact situation you have (the size of the tables, > > the size of the data to be loaded, the type of environment and so on.) > > > > Regards, > > Sebastian Paul A. > > E-mail: proteus@romus.com > > > > Sherwin (28.05.1999 14:56): > > >Can all indexes on a table in an Informix Database be turned off and > > >then turned on again later. I need to speed up loading of data into my > > >tables. But I don't wana drop and recreate my indexes, neither do I want > > >them slowing down my data insertion. > > > > > >sherwin > > > > > > > > >
John, I would think they should take the same amount of time since they're basically performing the same function, but I must admit, I haven't tested this. I would think enable/disable would be easier since you don't have to save out to file or go looking for your index's DDL. Kind regards, John Bejarano. Carlson@WHSmith wrote in message <374EF31B.ADE3BE6C@bellsouth.net>... >But which is faster, enable / disable or drop / recreate? > >I've always dropped and recreated, myself. > >John Carlson >Informix DBA >WHSmith USA > > >sherwin wrote: >> >> Hi, >> You are absolutely right. The point that once lots of data have been added >> into the tables the indexes are out dated any way (even if they are turned off >> and on. I have come to realize that you can turn on and off Indexes with >> Informix Dynamic Server). Some how the bell did'nt ring in my head. Without >> doubt now , I will delete and recreate my Indexes. Thank you for the >> enlightenment. >> >> sherwin >> >> Sebastian Paul Avarvarei wrote: >> >> > Hi! >> > >> > I can't think of any method of temporarily turning off the indexes (but >> > I'm not very experienced). >> > >> > But I can't find any reasons for doing so. Even you could stop and restart >> > the indexes, after restart they would have to be recreated for the new lines >> > anyway. >> > >> > On the other hand, if you don't have frequent inserts/updates, just big >> > load jobs from time to time, dropping and recreating the indexes would >> > allow you to create better indexes, with a big fillfactor. Maybe it would >> > be a good idea to post the exact situation you have (the size of the tables, >> > the size of the data to be loaded, the type of environment and so on.) >> > >> > Regards, >> > Sebastian Paul A. >> > E-mail: proteus@romus.com >> > >> > Sherwin (28.05.1999 14:56): >> > >Can all indexes on a table in an Informix Database be turned off and >> > >then turned on again later. I need to speed up loading of data into my >> > >tables. But I don't wana drop and recreate my indexes, neither do I want >> > >them slowing down my data insertion. >> > > >> > >sherwin >> > > >> > > >> > >