Sean, I dont have other connections to database - I am runing it on my development machine. timing for the second run never was a problem - second query with same params is exretmly fast. Problem is that I dont have 2 same params never one after first. And, whenever I change params, first query is relatively slow.
regarding header stats Oldest transaction 2020 Oldest active 2021 Oldest snapshot 2021 Next transaction 2035 I have 8 gb of Ram. db size is about 26 GB. Page size of database is 4096. Index stats of LINK_LA_TYP_IDX5 is 0.000000105665. Selectivity of the fields in link_la_typ is: lat_ga_id = 2470 / 125.000.000 lat_la_id = 17.500.000 / 125.000.000 it seems that I cant do it much faster, altough I tought it is possible after changing parameter in where clause. Regards, Zoran
