Re: Why does my process hang?

Francis Small (fthes_at_sr.hp.com) wrote:

: An index does indeed solve the problem for the example I gave, but
: unfortunately not in my application even after I added indices :-(.
: Back to re-boiling my situation for the essentials...

Oooooooh, you probably meant to build an index ** on the foreign key ** in the child table. I just plopped an index on some other fields (thinking "this is stupid... which should the mere fact of adding an index to the table change anything?"). But when I put an index on to the foreign key itself - bingo! - problem solved.

Moral: Always index your foreign keys for maximum concurrency.

  Francis

--
| . . . . 5 . . . . 10. . . . 15. . . . 20. . . . 25. . . . 30. . . . 35. . .

Padres                                         Francis Small - M/S M1RA     
Giants                                           Test Engineering
Bums                                               Microwave Instruments Div.
Rockies                                              telnet 794-3305
Diamondbacks                                           fthes_at_sr.hp.com
******************** Only 53 days left until Opening Day ********************