Re: Preventing Indexes on Foreign Keys

>>> Peter Lancashire <Peter.Lancashire.PL1@bayer.co.uk> 24/03/98 00:02:08 = >>> I agree it would be nice to have the option for lookup tables which are essentially fixed - they don't change so you never need to look up their foreign keys. On the rare occasiona you do, the optimizer might make you a temporary index. - --- ++++++++++++++++++++++++++++++++++++++++ Has anyone mentioned using check constraints. Personally I don't have any = problems with FKs creating indexes, but if people are concerned about the = oltp hit of maintaining them, and if there lookup values are essentially = stable, then I would have thought that specifying a domain with the check = statement would be the answer. rgds Peter Tashkoff <tashkop@iname.com> Zespri International Limited Std Disclaimers Apply All rights reserved. No party may use this document to vilify another. Zespri New Zealand Kiwifruit, The World's Finest