The most important issues are that you avoid full table scans, reuse open data paths and minimize the amount of I/O to accomplish each request. If the same SQL request is running 8,000 times per day, it needs some attention to its performance. CREATE INDEX versus CRTLF doesn't usually matter as much as you think.