How do we determine which column/s to be set when creating an INDEX?
As I understand, using INDEX the query will be more faster then without
using INDEX.
How about using INDEX if query is a JOIN query, which involved 4 tables.
---(end of broadcast)-
On Sun, Jan 14, 2001 at 04:46:08AM +0100, Alvar Freude wrote:
> Peter Eisentraut schrieb:
> >
> > > today i was trying to perform a query on a database using a time stamp
> > > field, i need to get all records which belong to year 2000, month 11,
> [...]
> > select user_name from tbacct whe
Hi,
Peter Eisentraut schrieb:
>
> > today i was trying to perform a query on a database using a time stamp
> > field, i need to get all records which belong to year 2000, month 11,
[...]
> select user_name from tbacct where extract(month from acct_timestamp) = 11 ...
is there any way of u
