Re: [PERFORM] Query with no result set, really really slow adding ORBDER BY / LIMIT clause

DESC limit 10 offset 0 Thanks for the help -- --- Ing. Marco Renzi OCA - Oracle Certified Associate Java SE7 Programmer OCP - Oracle Certified Mysql 5 Developer via Zegalara 57 62014 Corridonia(MC) Mob: 3208377271 "The fastest way to change yours

Re: [PERFORM] Query with no result set, really really slow adding ORBDER BY / LIMIT clause

This could look strange, but is fast as hell! The main problem is: Is everytime ok doing query like this with order by and limit? Is ok using an upperlimit to 1.000.000.000 records? SELECT * FROM ( SELECT fase.id FROMtipofase JOIN fase ON (fase.tipofase = tipofase.id) WH

Re: [PERFORM] Query with no result set, really really slow adding ORBDER BY / LIMIT clause

ms Execution time: 396555.499 ms -- 2017-04-20 13:54 GMT+02:00 vinny : > On 2017-04-20 13:16, Marco Renzi wrote: > >> Thanks Philip, yes i tried, but that is not s

Re: [PERFORM] Query with no result set, really really slow adding ORBDER BY / LIMIT clause

Thanks Philip, yes i tried, but that is not solving, still slow. Take a look at the log. -- Limit (cost=3.46..106.87 rows=10 width=4) (actual time=396555.327..396555.327 rows=0

[PERFORM] Query with no result set, really really slow adding ORBDER BY / LIMIT clause

quot;alter table tipofase alter column agendafrontoffice set statistics 2" but nothing. Thanks in advance Marco -- ------- Ing. Marco Renzi OCA - Oracle Certified