Re: Regarding INFORMIX Basic Details

Fernando Nunes wrote:
> DA Morgan wrote:
>> Obnoxio The Clown wrote:
>>
>>>> 5. What are the ways to tune a procedure in INFORMIX ?
>>>
>>> Huh?
>>
>> Most database products contains a profiler that shows which lines
>> are executed, how many times, the amount of time spent executing
>> that line, you know ... a tuning tool.
>>
>> I believe Informix does provide this capability too. <g>
> 
> Did you ever bother looking at the SPL statements? Do you need to tune 
> them?
> You can trace them of course...
> One nice capability that SPL has is the ability to honor the user's role

> and the privileges it gives the user... <G>

You are correct that some times tuning is not necessary. But when
someone asks a question about tuning ... that generally indicates
that they have a need to do so.

BTW: Honoring the user's role and privilege is something built into
each  and every one of the top five commercial RDBMS products.
-- 
Daniel A. Morgan
University of Wa****ngton
damorgan@[EMAIL PROTECTED]
 (replace x with u to respond)