SQL Performance RRS feed

  • Question

  • I am having a SQl Database in 2008 which contain nearly 400 tables.

    In that database foreign key has not been used they have created logical check while retriving and updating the data to those table .

    As they contain composit key in some table ,

    so i would like to know weathere it will effect the performance.

    as foreign key are not there .

    please provide the compleate answer with any link if there.

    Please Mark the answers and give points it will help users Thanks & Regards, Kamal Agarwala
    Monday, September 6, 2010 2:37 PM