It is based on the time consumed to fetch the result set of the select statment. If the select statment is taking time to retrieve the data it mean that it is using the full table scan and no indexes or wrong indexes has been created in table