db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mike Matrigali <mikem_...@sbcglobal.net>
Subject Re: jira question
Date Thu, 04 Aug 2005 23:00:01 GMT
yes, and then costing and choosing an index based on the expression if
it is the best way to execute the query.

Manish Khettry wrote:

> On 8/3/05, Mike Matrigali <mikem_app@sbcglobal.net> wrote:
> 
>>I don't think I am willing to say generated columns are not useful without
>>indexes, sorry if previous email led to that, actually I have not
>>actually thought much about it.
>>
>>I believe I was letting
>>my predjudice through, I have always thought that an interesting set
>>of problems could be solved if the optimizer work was done - so I
>>was concentrating on that.  And I see that optimizer work as a stepping
>>stone to even more possible interesting stuff in the future - things
>>like gist indexes.
>>
> 
> 
> So the optimizer work that you speak of is being able to check if two
> expressions are equivalent?
> 

Mime
View raw message