|
|
Posted by francois.bourdages on 06/13/06 12:47
A good rule of thumb :
1) index all FK.
If you have time and money :
Analyse all your query, and you will be able to get advise on all the
index you need.
If you dont have time or money :
Start working on long query first, and optimize them. You will get big
result fast.
90% of all performance probleme i have seen in the past are from query.
(query itself or logic in the design) . Not network, not RAM, or CPU,
not disk.
So start there.
Navigation:
[Reply to this message]
|