Re: Help building indexes

Posted in 1996

Bret Lowry — Fri, 13 Dec 1996 22:22:53 -0500 — source: Informix-list mailing list archive (1991-1998)

Saul Rubin wrote: > > Hi all, > A little while ago, I posted asking for help in loading a table > with 20-50 million records. Many of you replied to me and your > responses were very helpful. However, I neglected to ask the most > important question... > How do I build the indexes quickly? Loading is fairly quick using > "load from ... insert into ..." > But building the indexes takes HOURS. > Any ideas?? > Thanx! > Saul > -- > Saul Rubin |*| Nynex Science & Technology > 1342 East 31st Street |*| 400 Westchester Avenue - Room T-1B > Brooklyn, NY 11210-5415 |*| White Plains, NY 10604 > 718-692-0393 saul@cnct.com |*| 914-644-2691 saul@nynexst.com Yeah, start them on Friday night and be patient. Sorry, obnoxious side coming out....Did you try setting pdqpriority high on the job that was building the index?