Table data size is 3 meg
Index_size is 1 gig,
I rebuilt the index and it did drop my a meg or so but index is still
1gig.
XML indexes are in play,
Why would the index be that big?
Thanks in advance,rDray
Can you post the DDL?
"rDray" <randy.dray@.gmail.com> wrote in message
news:1162846100.891547.231880@.h54g2000cwb.googlegroups.com...
> Table data size is 3 meg
> Index_size is 1 gig,
> I rebuilt the index and it did drop my a meg or so but index is still
> 1gig.
> XML indexes are in play,
> Why would the index be that big?
> Thanks in advance,
>|||Thanks for responding, I am Green, What and how do you post the DDL?
Thanks
Uri Dimant wrote:
> rDray
> Can you post the DDL?
>
> "rDray" <randy.dray@.gmail.com> wrote in message
> news:1162846100.891547.231880@.h54g2000cwb.googlegroups.com...
> > Table data size is 3 meg
> >
> > Index_size is 1 gig,
> >
> > I rebuilt the index and it did drop my a meg or so but index is still
> > 1gig.
> > XML indexes are in play,
> >
> > Why would the index be that big?
> >
> > Thanks in advance,
> >|||"rDray" <randy.dray@.gmail.com> wrote in message
news:1163162103.739927.217160@.k70g2000cwa.googlegroups.com...
> Thanks for responding, I am Green, What and how do you post the DDL?
A script to recreate the database and some example data.
> Thanks
>
> Uri Dimant wrote:
>> rDray
>> Can you post the DDL?
>>
>> "rDray" <randy.dray@.gmail.com> wrote in message
>> news:1162846100.891547.231880@.h54g2000cwb.googlegroups.com...
>> > Table data size is 3 meg
>> >
>> > Index_size is 1 gig,
>> >
>> > I rebuilt the index and it did drop my a meg or so but index is still
>> > 1gig.
>> > XML indexes are in play,
>> >
>> > Why would the index be that big?
>> >
>> > Thanks in advance,
>> >
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment