Originally posted by menzi I've been informed that Indexes is a method which could be used to improve performance
Wow, you are, indeed, a beginner. If you just found out about indexes, you have a very long journey ahead of you. You are likely going to need far more instruction than a simple forum can provide. I suggest you do a lot of reading. Starting with a good SQL book would be a start.
Originally posted by menzi one way to measure performance is by length of time
While basically true, this can be very misleading. There are many variables involved with how long it actually takes a statement to execute. One of the biggest variables is caching. You basically need to keep running the statement until it stops getting faster. This will give you a base time against which to do comparisons. Then, after you make any changes, you must perform the same exercise again to get another comparison point. And remember that time is only one way of measuring performance.
Originally posted by menzi Can anyone suggest two performance critical transaction methods which involve