[Info-Ingres] Building of indexes

[Roy Hann]

<CLDWesterhof at gmail.com> wrote in message 
news:1174465524.992036.86210 at n76g2000hsh.googlegroups.com...
> We have an index where one off the values can get a negative value. It
> looks like when a record contains a negatve value, the record is not
> put into the index. Making queries very long. Is this correct? If so,
> what can be done about it?

It would be easy enough to tell if the value got into the index--it is just 
a table; query it and see if your value is there.  But that's not really 
necessary because if the value wasn't in the index the query would be just 
as fast, but the row for the negative value would not be returned.

You might try running the query with SET QEP to see if some silly plan is 
being chosen.  Also check to see if there are statistics on the columns that 
appear in the WHERE clause of your query.

Is the table very busy?  If you are using an isolation level higher than 
READ COMMITTED you might just be suffering from lock contention.

Roy