Hi all,
I have a table with 3,000,000 of rows, I have two index:
idx1 on --> (f_name,s_name,f_lastname,s_lastname)
idx1 on --> (f_name,f_lastname)
if the query is on 4 columns of the idx1, the result is speed, but if teh
query is on two columns of the idx2 the rsult take 10 minutes.
My postmaster run with option -S -o -F for best performance, but the
results is very slow.
I need suggestions, Thanks in advance,
Regards,
"La Vida"