> -Original Message-
> From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
> ow...@postgresql.org] On Behalf Of amit sehas
> Sent: Tuesday, August 14, 2012 12:55 PM
> To: pgsql-...@postgresql.org; pgsql-general@postgresql.org
> Subject: [GENERAL] Indexing qu
amit sehas wrote:
> In SQL, given a table T, with two fields f1, f2,
>
> is it possible to create an index such that the same record is indexed
> in the index, once with field f1 and once with field f2. (I am not
> looking for a compound index in which the key would look like f2>, instead the
In SQL, given a table T, with two fields f1, f2,
is it possible to create an index such that the same record is indexed in the
index, once with field f1 and once with field f2. (I am not looking for a
compound index in which the key would look like , instead there should
be two entries in the
On Thu, Jan 12, 2006 at 01:16:00PM -0800, Mike wrote:
> Hi,
>
> My table structure is the following:
>
> tbl_A one-to-many---> tbl_B one-to-many---> tbl_C
>
> Since it was important for me to trace back tbl_C records back to
> tbl_A, I placed a tbl_A_id inside tbl_C.
>
> Now, in order t
Hi,
My table structure is the following:
tbl_A one-to-many---> tbl_B one-to-many---> tbl_C
Since it was important for me to trace back tbl_C records back to
tbl_A, I placed a tbl_A_id inside tbl_C.
Now, in order to optimize my database for speed, I want to index my
tbl_B for it's tbl_A_
