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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

performance on query

Status
Not open for further replies.
raji96

raji96

Programmer
Aug 7, 2001
64
US
I have a query which is run on an external database, to which i have only select priveledges on 4 tables, but since the response time is pretty slow, I just wanted to see what is happening with the queries. Is it possible to run explain even though I have only limited access? If not what is the better solution to see the track of the query?


Thanks!
 
Sort by date Sort by votes
Well, why not try running explain on your query and see?

Elbert, CO
0837 MST
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Chopstik
  • Locked
  • Question
How to identify a package based on a code snippet 1
Replies
1
Views
335
Andrzejek
Andrzejek
Livia8
  • Locked
  • Question
Generate report/output on the basis of "enquiry" responsibilities only 1
Replies
16
Views
183
Livia8
Livia8
kernal
  • Locked
  • Question
If there is a Fee on Class Level then that fee overrides Fee on Course Level 1
Replies
3
Views
106
kernal
kernal
Andrzejek
  • Locked
  • Question
Detect ON DELETE CASCADE in tables 1
Replies
4
Views
172
Andrzejek
Andrzejek
ssmith999
  • Locked
  • Question
Query help w/ fiscal calendar query
Replies
1
Views
86
johnherman
johnherman

Part and Inventory Search

Sponsor

Back
Top