Dear sir ,

I have big problem in DB9.5 workgroup

When I query a few data.The DB has response to slow
but I query large data The DB has response to fast

What is this problem and resolve it?

P.s. I have been create index and run stat.

Thk.

try explain. if that does not help you then you should find answer on page 193.

page 193 of???

of 300

What is URL ? I don't know it.
Please Tell me .

Thank you so much.

Sorry about that, but Cougar and I could not help but be sarcastic, though it would have been better for Cougar to have given a tiny URL to point you to the movie 300.
You did not ask a real question that anyone could give a beneficial answer. If you would like help on a question you have to be more specific. The general things you should do when you have a slow query is to review the SQL. You run an explain of that SQL statement to see how it is accessing the database, is it using indexes or scanning every row, do you have a cartesian or partial cartesian product (you are not joining tables by the key or only by part of the key that links the tables), you are, maybe materializing a huge intermediate resultset, maybe your bufferpools have zero memory allocated to them, maybe you are having problems with your disk I/O rate, etc... You gave us no information to help you.
Maybe you need to look at some of the items I mentioned above, maybe the SQL being executed is just poorly written, give us the query, ddl of the tables being queried, some sample data and expected results.
Dave