5 Replies Latest reply: Mar 14, 2014 9:43 AM by kazyskiyn0w RSS

    create index in FK

    kazyskiyn0w

      Hi All,

       

      I know that a Foreign Key withou index can be a performance issue and also can cause locks in some cases.


      Can someone show me in a simple example how to create a index in a foreign key using Scott tables example?

       

      Or show me a web page where I can find it? I researched the web and did not find a good example.

       

      Thanks ,

      KZ