Hi
I have created the following 2 views:
CREATE VIEW `cpes_noise_num` AS
SELECT cpes_dsl_line_stats.id_cpes,
sum(IF(cpes_dsl_line_stats.snr_downstream
(SELECT snr_downstream FROM admin_configs WHERE admin_id =0),1,0)) AS
snr_downstream, sum(IF((cpes_dsl_line_stats.bit_errors /
In the last episode (Jun 10), Yariv Omer said:
I have created the following 2 views:
CREATE VIEW `cpes_noise_num` AS
[ big view]
CREATE VIEW `my_connect` AS
[ big view joining on cpes_noise_num ]
when I am trying to do something like:
SELECT count(*) from my_connect
It takes 1 minute