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.