I would pull each one of the selects out of the set of SPs you have,
simplify them if into clauses etc are used, Then run each one to see which
plan it is using, there's bound to be at least one or more using a natural
plan which slows things down considerably. Then re-arrange the where clause
of the culprit till you use an index.
That may be the slow way but you really see what's going on
Alan
-----Original Message-----
From: mircostange [mailto:mirco@...]
Sent: Friday, 11 October 2002 16:55
To: ib-support@yahoogroups.com
Subject: [ib-support] 3rd attempt: HELP needed for optimization


Still didn't have any feedback regarding optimization support. The
issue is: how can I analyze how much time IB/FB spends with the
execution of a number complex queries involving UDFs and stored
procedures to get a hint why those queries are relatively slow?

No one out there having an idea on this or is this just the wrong
group?

Thanks anyway


Yahoo! Groups Sponsor
ADVERTISEMENT





To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]