> Hi, > > This is really weird. > > I cannot see why a NATURAL plan is being used instead of my index, I am not > doing anything fancy. > > Using: FB2.5.1 32 bit classic server > > Query: > > select t.SalesOrderNo from stk_stocktransaction t > where (t.SourceType = 34) > and (t.TransactionType = 'EXTCST') > and (t.RefNo = 'I00001') > > Plan is: > PLAN (T NATURAL) > > Yet I have the following index: SourceType, TransactionType, RefNo asc > > With selectivity: 0.0000049.... > > Table has 1.4 million records. > > Query does 1.4 million non-indexed reads, and takes 11 to 20 seconds to > return no records (for the parameters I have selected) > > My development database DOES use the index. > > Please help! Is this a bug, or am I missing something! > > How can I force it to use the index, to see if it is any faster?
Is the index by any chance inactive, e.g. due to a restore without indexes etc ... -- With regards, Thomas Steinmaurer http://www.upscene.com/
