Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 1 down vote favorite

I have SQL Server 2005. Tables have relations which each others. Some tables are libraby. 1 table has 10 foreign relations. I dont like the Database performance, a little slowly and I dont know what is the problem. Foreign relations can do it? Generally foreign key how influence the database performance?

share|improve this question
   
Did you put indexes on your columns? – Maryam Arshi Feb 27 at 9:13
Some columns gave indexes – Ebu Yusif Feb 27 at 9:42
May putting Indexes on foreign keys too helps. – Maryam Arshi Feb 27 at 9:53
If everything (all databases, all operations) on your database server is slow, than it MAY be a server problem. If only one specific database is slow, than it MAY be a setting, or some specific operation that's slowing down or blocking the others. If only some specific queries are slow, you might go into indexing for specific needs. Creating indexes on ALL foreign keys is not a start, but trying to narrow your problem is. So, start answering the following question: what is slow? – Marian Feb 27 at 10:06
i think i needn`t give foreign key for all relations, isnt true? – Ebu Yusif Feb 27 at 10:18
show 3 more comments

closed as not constructive by Jon Seigel, Leigh Riffel, Mark Storey-Smith, Paul White, dezso Feb 28 at 8:06

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or specific expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, see the FAQ for guidance.