Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gmmastros on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Does anybody know some tools to analyze SQL code against the schema?

Status
Not open for further replies.
pengzhang

pengzhang

Technical User
Oct 19, 2002
22
0
0
CA
Hi Guys,

I'm looking for tools for Informix (or some general tools for all databases) to analyze SQL code against the schema to see if there are some performance issues?

Thanks
 
Sort by date Sort by votes
you have great tool known as Server Studio to connect to the Informix Server.
and Informix native connecting tooll "dbaccess" in that you can use Explain plan to explain the query path. enjoy
 
Upvote 0 Downvote
... also native informix tool "onperf", which gives graphical representation of the current operating metrics!

Enjoy!

Fester
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

jamescpp
  • Locked
  • Question
listener-thread: err = -25572: oserr = 226: errstr = : Network driver cannot bind a name to the port
Replies
0
Views
45
jamescpp
jamescpp
KaronW
  • Locked
  • Question
Do multiple "case" lines run against each line or is each run against the table ?
Replies
0
Views
35
KaronW
KaronW
arunkumar.ceg
  • Locked
  • Question
How to call informix 4gl from script
Replies
0
Views
46
arunkumar.ceg
arunkumar.ceg
cwbloucks
  • Locked
  • Question
Informix SQL Update using an inner join
Replies
0
Views
64
cwbloucks
cwbloucks
kray4660
  • Locked
  • Question
Trying to do a count on logged in users
Replies
1
Views
48
kray4660
kray4660

Part and Inventory Search

Sponsor

Back
Top