NOT ENFORCED RI - what optimization opportunities are missed?

November 12th, 2008, 08:05 PM

PaulR

Guest

Posts: n/a

Hi,

(ignoring data integrity benefits)

we would like to understand the extent of the optimization benefits
missed for selects when using
DISABLE QUERY OPTIMIZATION on NOT ENFORCED FK constraints?

Thanks.

« previous question | next question »

/bytes/development

/bytes/it

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 225,662 network members.