Re: Function Based Index

From: Purav Chovatia <puravc_at_gmail.com>
Date: Fri, 14 Sep 2012 01:10:34 +0530
Message-ID: <CADrzpjE4UbSP28h3+zT7rOH72mXVmgB31ihfzAhXvSNszGNuAQ_at_mail.gmail.com>

FBI creation statement:
create index ixxx_mxxxxxxxxx_mxxxxxx_IDX2 on ixxx_mxxxxxxxxx_mxxxxxx(trunc(rectimestamp)) compute statistics;

thanks.

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Sep 13 2012 - 14:40:34 CDT