Answered Questions

  • Search Method

    If the large table contains thousands of records and the application is accessing 35% of the table which method to use: index searching or full table scan?

    SSR

    • Jul 20th, 2011

    Depends on cardinality, for low cardinality then full scan better