Re: Regarding INFORMIX Basic Details

DA Morgan wrote:
> 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.

The OP is coming from an Oracle background (uau)... As normal he wants to
know 
how to do what he used too... If he had a specific issue he surely would
have 
post it... As you can read(?) all he's questions were generic. Easy to 
understand but not very convenient for your purposes.


> 
> BTW: Honoring the user's role and privilege is something built into
> each  and every one of the top five commercial RDBMS products.

Already discussed here and people can find info about it on the Internet.

Regards.