Optimization

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.
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.
>
|||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[vbcol=seagreen]
> to manipulate.
> John
> "John" <naissani@.hotmail.com> wrote in message
> news:%23Hhk6pJMFHA.1472@.TK2MSFTNGP14.phx.gbl...
are
>
|||Hi
By using a temporary table to restrict the data you are looking at, it
may be possible to create a more proformant than it would be otherwise.
e.g
http://www.windowsitpro.com/SQLServe...hreadid=102472
With SQL 2000 table variables were introduced as an alternative to
temporary tables.
http://www.windowsitpro.com/Articles...layTab=Article
Using temporary tables may introduce it's own problems
http://www.sql-server-performance.co...ottlenecks.asp
and using them unnecessarily may also degrade performance
http://www.sql-server-performance.co...ved_tables.asp
Therefore you would have to try out different methods to see what is
the best in your circumstances.
John
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[vbcol=seagreen]
> trying
> to manipulate.
> Thanks.
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:#vpfVfSMFHA.1176@.TK2MSFTNGP12.phx.gbl...
your[vbcol=seagreen]
as well[vbcol=seagreen]
option if[vbcol=seagreen]
change the[vbcol=seagreen]
would[vbcol=seagreen]
> be
are[vbcol=seagreen]
> trying
there[vbcol=seagreen]
> are
the fast[vbcol=seagreen]