|
-
Hi Chris,
Yeah I agree on you with what goes inside the (). I just wanted to make sure to point out that if you add the hint
you can really speed things up, since everybody is looking
for the fastest ways to count records but nobody mentioned
it. You'd think the optimizer would be smart enough to
figure out to use the index without a hint, but it (at least
in my experience) isn't.
-John
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|