wangbo commented on issue #8388:
URL:
https://github.com/apache/incubator-doris/issues/8388#issuecomment-1062503911
## Performance Test
1 whether the performance improves when query without indexes
1.1 sql with string type
```
SELECT
count(distinct P_CATEGORY)
FROM lineorder_flat
```
before:
- BlockLoadTime: 4s787ms
after:
- BlockLoadTime: 4s052ms
1.2 sql with integer
```
select sum(LO_EXTENDEDPRICE * LO_DISCOUNT) from lineorder_flat
```
before:
- BlockLoadTime: 2s590ms
after:
- BlockLoadTime: 1s528ms
2 Whether the performance falls back when query with index
```
SELECT sum(LO_EXTENDEDPRICE * LO_DISCOUNT) AS revenue
FROM lineorder_flat
WHERE LO_ORDERDATE >= 19930101 and LO_ORDERDATE <= 19931231 AND LO_DISCOUNT
BETWEEN 1 AND 3 AND LO_QUANTITY < 25;
```
before:
- BlockLoadTime: 1s208ms
after:
- BlockLoadTime: 1s045ms
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
