Faster alternative in Oracle to SELECT COUNT(*) FROM sometable

by

If you want just a rough estimate, you can extrapolate from a sample:

SELECT COUNT(*) * 100 FROM sometable SAMPLE (1);

For greater speed (but lower accuracy) you can reduce the sample size:

SELECT COUNT(*) * 1000 FROM sometable SAMPLE (0.1);

For even greater speed (but even worse accuracy) you can use block-wise sampling:

SELECT COUNT(*) * 100 FROM sometable SAMPLE BLOCK (1);

More Related Contents:

  1. Printing the value of a variable in SQL Developer
  2. Oracle Equivalent to MySQL INSERT IGNORE?
  3. null vs empty string in Oracle [duplicate]
  4. Convert comma separated string to array in PL/SQL
  5. UTL_FILE.FOPEN() procedure not accepting path for directory?
  6. Oracle stored procedure with parameters for IN clause
  7. PL/SQL ORA-01422: exact fetch returns more than requested number of rows
  8. NLS_NUMERIC_CHARACTERS setting for decimal
  9. Formatting DATE in oracle
  10. What is the minimal setup required to deploy a .NET application with Oracle client 11?
  11. Oracle: How to find out if there is a transaction pending?
  12. Best practice for pagination in Oracle?
  13. check if “it’s a number” function in Oracle
  14. Sql*plus always returns exit code 0?
  15. HIbernate issue with Oracle Trigger for generating id from a sequence
  16. error: ORA-65096: invalid common user or role name in Oracle database
  17. Using Alias in query resulting in “command not properly ended”
  18. Spring boot Hibernate error “Access to DialectResolutionInfo cannot be null when ‘hibernate.dialect’ not set” when working with multiple data sources
  19. How to insert a column in a specific position in oracle without dropping and recreating the table?
  20. Is it possible to kill a single query in oracle without killing the session?
  21. Get the LENGTH of a LONG RAW
  22. MySQL equivalent of ORACLES rank()
  23. Reading clob line by line with pl\sql
  24. Oracle: Days between two date and Exclude weekdays how to handle negative numbers
  25. merge update oracle unable to get a stable set of rows
  26. How to get the week day name from a date?
  27. DBMS_JOB vs DBMS_SCHEDULER
  28. How to change default nls_date_format for oracle jdbc client
  29. How to generate a GUID in Oracle?
  30. Escaping single quote in PLSQL

Leave a Comment