"John" <naissani@hotmail.com> wrote in message
news:%23Hhk6pJMFHA.1472@TK2MSFTNGP14.phx.gbl...
>I just wanna know what is the optimized way for fast retrieval if there are
> billions of rows in a single table.
>
> Can any one let me know any idea except table partitioning for the fast
> retrieval of data
>
> Thanks in advance.
>
>

"John Bell" <jbellnewsposts@hotmail.com> wrote in message
news:#vpfVfSMFHA.1176@TK2MSFTNGP12.phx.gbl...
> Hi
>
> Optimization needs to take into account the whole environment of your
> application and be part of your design. This will include hardware as well
> as the software. Partitioned views (see Books online) may be an option if
> you have the hardware to run them on, if you are not wanting to change the
> design look at what indexes are available. Other things to look at would
be
> using table variables or temporary to reduce the size of data you are
trying
> to manipulate.
>
> John
>
> "John" <naissani@hotmail.com> wrote in message
> news:%23Hhk6pJMFHA.1472@TK2MSFTNGP14.phx.gbl...
> >I just wanna know what is the optimized way for fast retrieval if there
are
> > billions of rows in a single table.
> >
> > Can any one let me know any idea except table partitioning for the fast
> > retrieval of data
> >
> > Thanks in advance.
> >
> >
>
>

John wrote:
> Thanks John but can you explain me more about Other things to look at
would
> be using table variables or temporary to reduce the size of data you
are
> trying
> to manipulate.
>
> Thanks.
> "John Bell" <jbellnewsposts@hotmail.com> wrote in message
> news:#vpfVfSMFHA.1176@TK2MSFTNGP12.phx.gbl...
> > Hi
> >
> > Optimization needs to take into account the whole environment of
your
> > application and be part of your design. This will include hardware
as well
> > as the software. Partitioned views (see Books online) may be an
option if
> > you have the hardware to run them on, if you are not wanting to
change the
> > design look at what indexes are available. Other things to look at
would
> be
> > using table variables or temporary to reduce the size of data you
are
> trying
> > to manipulate.
> >
> > John
> >
> > "John" <naissani@hotmail.com> wrote in message
> > news:%23Hhk6pJMFHA.1472@TK2MSFTNGP14.phx.gbl...
> > >I just wanna know what is the optimized way for fast retrieval if
there
> are
> > > billions of rows in a single table.
> > >
> > > Can any one let me know any idea except table partitioning for
the fast
> > > retrieval of data
> > >
> > > Thanks in advance.
> > >
> > >
> >
> >