Dear Rick,
Yes I have change and put exactly as per your suggestion the where clause.I am using innodb as I think is better option then myisam right?
1.For this SHOW TABLE STATUS LIKE 'tbl'\G ; it tells me I have syntax error near 'tbl'\G
2. I manage to get the select but without the \G
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE tblLocationFrom ALL NULL NULL NULL NULL 119
1 SIMPLE tblLocationTo ALL NULL NULL NULL NULL 119
1 SIMPLE tblScvData range dateTime dateTime 8 NULL 399 Using where
1 SIMPLE tblAssociate eq_ref PRIMARY PRIMARY 4 scv.tblScvData.associateID 1 Using where
3. Show buffer results.
bdb_log_buffer_size 262144
bulk_insert_buffer_size 8388608
innodb_buffer_pool_awe_mem_mb 0
innodb_buffer_pool_size 8388608
innodb_log_buffer_size 1048576
join_buffer_size 131072
key_buffer_size 8384512
myisam_sort_buffer_size 8388608
net_buffer_length 16384
preload_buffer_size 32768
read_buffer_size 131072
read_rnd_buffer_size 262144
sort_buffer_size 2097144
About ram since is just a test machine is loaded with 1GB Ram on Centos.