|
Home > Archive > MS SQL Server > June 2005 > Vertical Partitions question
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Vertical Partitions question
|
|
| strout 2005-06-29, 1:23 pm |
| Is there any other techniques to partition the table and make the performance
faster.
We have a table with sveral years of data, around 30 million records. The
"DateKey" field is used frequently. Even though we add index on the fields,
it's still very slow. Is there a way to run a query against part of the
records by filtering a field?
I would say vertical partitions are perfect for this but how can I do it? We
have an indentical replicate DB.
TIA
| |
| Narayana Vyas Kondreddi 2005-06-29, 1:23 pm |
| Please do not multi-post. I've responded in the .programming group.
--
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/
"strout" <strout@discussions.microsoft.com> wrote in message
news:8E1C62B1-94C9-44A8-B883- F7E55D4D5A63@microso
ft.com...
> Is there any other techniques to partition the table and make the
performance
> faster.
>
> We have a table with sveral years of data, around 30 million records. The
> "DateKey" field is used frequently. Even though we add index on the
fields,
> it's still very slow. Is there a way to run a query against part of the
> records by filtering a field?
>
> I would say vertical partitions are perfect for this but how can I do it?
We
> have an indentical replicate DB.
>
> TIA
| |
| Adam Machanic 2005-06-29, 1:23 pm |
| Sounds like a horizontal partition, not vertical. Horizontal is partitioned
by rows, vertical is partitioned by columns (imagine looking at a table on
the screen). What it sounds like you want to do is break up the table based
on that "DateKey" column.
That can be accomplished using partitioned views. Look it up in Books
Online for more information.
--
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"strout" <strout@discussions.microsoft.com> wrote in message
news:8E1C62B1-94C9-44A8-B883- F7E55D4D5A63@microso
ft.com...
> Is there any other techniques to partition the table and make the
performance
> faster.
>
> We have a table with sveral years of data, around 30 million records. The
> "DateKey" field is used frequently. Even though we add index on the
fields,
> it's still very slow. Is there a way to run a query against part of the
> records by filtering a field?
>
> I would say vertical partitions are perfect for this but how can I do it?
We
> have an indentical replicate DB.
>
> TIA
|
|
|
|
|