Hi,
I am having Customer ID as primary key for my customer table. I found that, it is slow for searching a customer record using either LOCATE FOR or SQL-SELECT. Therefore, I set Customer ID as regular key in table as well. It really optimized the query. The speed of search is just like "light of speed".
Why could it happen?
Thank you
I am not the most powerful man in this world.
I am not the worst man in this world either.
I just as same as all of you.
I still need to learn from my mistakes...