-
I WANT TO KNOW IF I HAVE RECORD IN MY TABLE BY DOING:
SELECT 'X'
FROM TABLE;
BUT THAT SELECT STATEMENT DOES A LOT OF PHISYCAL READ.
IS THERE A WAY TO FIND OUT IF THERES RECORD IN MY TABLE WITHOUT DOING A LOT OF PHYSICAL READ?
I ALSO DID :
SELECT COUNT(*)
FROM TABLE;
AND IT DOES LESS PHISICAL READ.
BUT I WANT BETTER PERFORMANCE.:)
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
|