Re: oracle equivalent of teradata's sparse index
- From: Jared Still <jkstill@xxxxxxxxx>
- To: dd.yakkali@xxxxxxxxx
- Date: Mon, 2 Aug 2010 19:28:10 -0700
On Mon, Aug 2, 2010 at 4:36 PM, dd yakkali <dd.yakkali@xxxxxxxxx> wrote:
> hello dbas,
>
> Some one asked me that teradata can create index for only a subset of rows
> of a table. We have a huge table (5 billion) which is for few months of data
> but the data for most part is accessed for yesterday. So the question is: is
> there any way to create index only for yesterday.
>
Sounds like a job for partitioning.
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog: http://jkstill.blogspot.com
Home Page: http://jaredstill.com
Other related posts: