>
>Dmitry,
>PMFJI but even with no indexes, nothing for optimization etc 5mins sounds too much for 150K records. Sounds like there is a problem in table header to me. Can you create a fresh copy of that table and try (with or w/o indexes, shared or exclusive).
>Networked? Faulty HW?
Cetin,
Exactly what I thought when they told me that it takes 5 minutes. Way too much time. It is possible that the person who was telling me was exaggerating and translating his "perception" into minutes. But the bottom line, the customer is not happy and I have to do something. I have just changed the query and sent them and update. If this does not improve the speed I will follow your suggestion and have them run a check on the table header.
Thank you for your help.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
