Re: SQL Tuning Question

SELECT COUNT(*) FROM prembr_834_lockupdt_ky;     -- 2979
SELECT COUNT(DISTINCT mbr_medicaid_id) FROM prembr_834_lockupdt_ky;  --- 2483 
SELECT COUNT(*) FROM prembr_834_data_ky;  ---  2966
SELECT COUNT(DISTINCT mbr_medicaid_id) FROM prembr_834_data_ky;  --- 2648
Thanks,
Lisa


________________________________
From: "Simoneau, Roger" <[email protected]>
To: "'[email protected]'" <[email protected]> 
Sent: Tuesday, February 28, 2012 10:21 AM
Subject: RE: [toad] SQL Tuning Question


  
A few count queries to run – if it’s ok for you to provide us with the counts.  Always be safe with regards any non-disclosure type agreement you may have signed.
 
SELECT COUNT(*) FROM prembr_834_lockupdt_ky;
 
SELECT COUNT(DISTINCT mbr_medicaid_id) FROM prembr_834_lockupdt_ky;
 
SELECT COUNT(*) FROM prembr_834_data_ky;
 
SELECT COUNT(DISTINCT mbr_medicaid_id) FROM prembr_834_data_ky;
 
Roger S.

________________________________
This communication, including any attached documentation, is intended only for the person or entity to which it is addressed, and may contain confidential, personal and/or privileged information. Any unauthorized disclosure, copying, or taking action on the contents is strictly prohibited. If you have received this message in error, please contact us immediately so we may correct our records. Please then delete or destroy the original transmission and any subsequent reply.