Re: Optimize a query
Thank you for your time Rick!
(Sorry for the late reply)
Nothing really changes when adding that index.
Well, yes the SELECT in the view returns 24K rows. But I always use a LIMIT value when I do queries on the view so it never actually returns that many rows (I guess?). I'm not that used to handling VIEWS so maybe I'm doing it wrong.
From now I will skip the VIEW and try to make it work without it.
I also upgraded my server to 1.5GB RAM and 2.4GHZ CPU.
Maybe it'll work better now :)
Subject
Views
Written By
Posted
2874
March 10, 2011 08:59AM
1402
March 13, 2011 03:48PM
1475
March 14, 2011 03:35PM
1486
March 14, 2011 06:26PM
1340
March 15, 2011 02:20PM
1379
March 15, 2011 09:12PM
Re: Optimize a query
1281
March 28, 2011 06:20AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.