On Thursday 17 Jul 2003 8:39 pm, Steve Crawford wrote:
> OK, so basically you are trying to keep a hundered some odd attributes on
> everyone in the US. It's possible that a 150 column table is properly
> normalized (I have a similar situation) but it is rare.
>
> Suppose it is really properly norm
"Girish Bajaj" <[EMAIL PROTECTED]> writes:
> I cant possibly index all the cols in the table. So I thought Id best manage
> the data by splitting up the table into multiple partitions and eventually
> depending on application logic, only scan those tables that are necessary to
> scan sequentially
real big
problem causing loads of sequential scans wouldn't it?
Thanks,
Girish
-Original Message-
From: Josh Berkus [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 17, 2003 2:03 PM
To: Richard Huxton; Girish Bajaj; [EMAIL PROTECTED]
Subject: Re: [SQL] Table Partitioning and Rules
Gir
al big
> problem causing loads of sequential scans wouldn't it?
>
> Thanks,
> Girish
>
>
> -Original Message-
> From: Josh Berkus [mailto:[EMAIL PROTECTED]
> Sent: Thursday, July 17, 2003 2:03 PM
> To: Richard Huxton; Girish Bajaj; [EMAIL PROTECTED]
&
Girish,
> I cant possibly index all the cols in the table.
Why not?
Seriously, what you can do is use query logging to log the columns and
combinations of columns that users most frequently ask for. Then you can
index for those queries.
Your partitioning scheme assumes that users will be s
ge-
From: Josh Berkus [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 17, 2003 2:03 PM
To: Richard Huxton; Girish Bajaj; [EMAIL PROTECTED]
Subject: Re: [SQL] Table Partitioning and Rules
Girish,
> > Essentially Im trying to store a persons information in a table in the
> > database. S
On Thu, 2003-07-17 at 19:03, Josh Berkus wrote:
> Girish,
>
> > > Essentially Im trying to store a persons information in a table in the
> > > database. Since we could have millions of people, with duplicates! Ive
> > > decided we need to partition the table into segments where all people with
> >
Girish,
> > Essentially Im trying to store a persons information in a table in the
> > database. Since we could have millions of people, with duplicates! Ive
> > decided we need to partition the table into segments where all people with
> > the LastName starting from A to G will be in one table. H
On Thursday 17 Jul 2003 6:20 pm, Girish Bajaj wrote:
> Hello All,
>
> I have a set of tables partitioned horizontally. DML below.
>
> Essentially Im trying to store a persons information in a table in the
> database. Since we could have millions of people, with duplicates! Ive
> decided we need to
