Hi Chetan,
Well, I would suggest to add separate index on
either on bsc_id or data_GenTime,
whichever returns smaller result.
Then check with explain that this index is used
May
chetan t wrote:
Hi mike,
as i have mentioned in my previous mail
the table structure which i am using is as fallows,
CR
Hi mike,
as i have mentioned in my previous mail
the table structure which i am using is as fallows,
CREATE TABLE IND_KAR_BNG_Metallica_PS_RT_4
(
gan_id INTEGER NOT NULL,
bsc_id INTEGER NOT NULL,
bts_id INTEGER NOT NULL,
bd_type VARCHAR(10) NOT NULL,
bd_i
