```
create or replace view site_count_for_records (site, url_count) AS (select newsite, count(url) as url_count from records group by newsite order by url_count DESC);
```
为了保存 group by 的结果,我建立了一个视图,但是悲剧的是我直接去这个新建的视图去查询怎么还是一样的慢呢?难道这个视图木有真正的保存查询结果?
create or replace view site_count_for_records (site, url_count) AS (select newsite, count(url) as url_count from records group by newsite order by url_count DESC);
```
为了保存 group by 的结果,我建立了一个视图,但是悲剧的是我直接去这个新建的视图去查询怎么还是一样的慢呢?难道这个视图木有真正的保存查询结果?