query 0911 logical

Hi,
I like to query 0911LA but it is not so kind to me. It is very slow. I am using an SQL query software and these are some of the the columns I need to return:

GLDCT,GLMCU, GLDOC etc
with following conditions:
(GLDGJ BETWEEN 103005 AND 103019) AND (GLOBJ = '1111')

I am trying to understand what makes a query go faster or slower. It seems when I add a date range it makes it go slow. Around 40 minutes or so.

I appreciate your help
Andonny

Andonny,
I believe that the most important factor is whether or not there is an index built on the table that matches pretty closely what sql statement is being used to access data.
Maybe add a new index to match.
I would not do this lightly, every index that is added adds overhead.
Regards,
Dave

I am so happy to hear from you. I have heard about indexes but I have no idea how to incorperate them in a query. I am not a database specialist but I would love to know how an index works in jde and where they are for me to use in a query. I am dying to find out as much as possible about them. I wouldn't be allowed to make a new one but I know there are lots of them already but I don't know how to use them.

I appreciate your help
Andonny