Query Excution Time

[s6868]

Question on query excution time. I have a mx application querying Oracle
database, there is about ten records only, but the debugging information show
32ms, 16ms, sometime 0ms. What could be the cause make the excution time varies.
here is my Query:
SELECT itemID
FROM TABLE
WHERE itemID ='157421'
AND ACTIVE='Y'

ItemID is varchar(2)
Active is Char(1)

Is it because the data type? I have other table queries are doing the same
thing. When you refresh the page, they give you a different excution time.

Any help will be appreciated!

Thanks,
Bill:confused;

[Dan Bracuk]

It depends on many things and is not worth worrying about.

Having item id as char instead of integer is rather odd. Are you not using sequences to generate your next value for the primary key?

[s6868]

Thanks Dan,
I would make Itemid a number, and active as well. I will found out whether they will let me make the database change.