RE: SQL Tuning Question

"Simoneau, Roger" <[email protected]>
Newsgroups gmane.comp.db.oracle.toad.free
Message-ID <85214F3A9C2FE94F9FF1D7C6456E33F9042D7643A5@EX-CLUS-MBX-01.abcp.ab.bluecross.ca>
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.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.