Hello,
Le 26/07/09 7:09, Greg Caulton a écrit :
On Sun, Jul 26, 2009 at 1:02 AM, Greg Caulton caulton...@gmail.com
mailto:caulton...@gmail.com wrote:
Hello,
It seems to me that the following query should be a lot faster.
This runs in 17 seconds (regardless how many times I
Hello,
It seems to me that the following query should be a lot faster. This runs
in 17 seconds (regardless how many times I run it)
select ac.* from application_controls_view ac, refs r where
ac.custom_controller_ref_id = r.ref_id and r.ref_key like '%XYZ%';
if I do not use the view the query
On Sun, Jul 26, 2009 at 1:02 AM, Greg Caulton caulton...@gmail.com wrote:
Hello,
It seems to me that the following query should be a lot faster. This runs
in 17 seconds (regardless how many times I run it)
select ac.* from application_controls_view ac, refs r where