also added hash indexes to queries