Complex methods

[Ruslan Zasukhin]

On 1/21/06 11:28 PM, "jda" <jda at his.com> wrote:

>> If you want in SINGLE QUERY and simpler,
>> then MAY BE you can try subselects.
> 
> Can you give me a crude (simple) example of what you mean?

    select ..
    from(  select .. from T where ... )
    where


>> Also you can think about methods. But NOT indexed.
>> And extract some part of formula into method(s)
>> 
> 
> Actually, this is a method now (not indexed). I make a temporary
> field with this method, the drop it after the sort.

Then you can split THIS method to SEVERAL, right ?


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]