Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-488

Index is not used for full table aggregation queries

    XMLWordPrintableJSON

Details

    • Task
    • Status: Resolved
    • Resolution: Fixed
    • None
    • None
    • None
    • 357

    Description

      Aggregation query like select count from t, select min(col) from t group by pk does not use index by default/without hint. Query execution time is faster if index is used.

      Attachments

        Activity

          People

            Unassigned Unassigned
            mujtaba Mujtaba Chohan
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: