Posts by Rogério Ribeiro • 21 points

• 2

  votes

  1

  answer

  4128

  views

  A: How to limit results on Oracle without reading the entire table?

  1- Be specific in your search; SELECT ACCT FROM ACCT_CUST AC WHERE AC.TYPE IN ("AA","BB") Using clause != you force the index to compare all different results of your result. 2- To improve the…

  oracle

  answered 9 years, 2 months ago Rogério Ribeiro 21