Hengky Liwandouw wrote:
>
> But the problem is : when i change the where clause to :
>
> where jualid is not null or returjualid is not null
> and extract(year from tanggal)='2013')
Try to create this index:
create index xxx on public.tbltransaksi((extract(year from tanggal)))
where jualid is
Friends, i need help.
I have query below that running well so far. it needs only 5.335 second to get
data from 803.583 records. Here is the query :
with qry1 as
(select tanggal, extract(month from tanggal) as bulan, tblsupplier.id, nama,
kodebarang, namabarang, keluar,
case when disc
On 30.11.2013 00:48, Tom Lane wrote:
Are you explicitly ANALYZE'ing the newly-built tables in your script,
or are you just trusting auto-analyze to get the job done?
Hi Tom,
there is an explicit analyze of the table being done between filling the
table with values and running this query. I sket
