Function Based Index Step by Step
alter session set query_rewrite_enabled=true;
alter session set query_integrity=trusted;
create index on orders(trunc(time));
analyze table orders compute statistics;
select /* +index(orders) */ * from orders where trunc(time)=trunc(sysdate);[@more@] need to research more ...
alter session set query_rewrite_enabled=true;
alter session set query_integrity=trusted;
create index on orders(trunc(time));
analyze table orders compute statistics;
select /* +index(orders) */ * from orders where trunc(time)=trunc(sysdate);[@more@] need to research more ...
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/205087/viewspace-786673/，如需转载，请注明出处，否则将追究法律责任。
转载于:http://blog.itpub.net/205087/viewspace-786673/
扫一扫
200
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
