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

SQLEXPLAIN output

Status
Not open for further replies.
voronovvoronov

voronovvoronov

Programmer
Joined
Feb 14, 2001
Messages
1
Location
US
does anybody have recommendations/references on how to use SQLEXPLAIN in order to optimize/evaluate heavy SQL statements ?

we have very heavy (time-consuming) SELECT statements and are trying to optimize them (we can't change indexes but want to adjust the statements to match the indexes as much as possible) .


Thanks, Alex.
 
Status
Not open for further replies.

Similar threads

88Pete88
  • Locked
  • Question Question
Supressing Column headings from sql output
Replies
1
Views
214
olded
olded
Navster
  • Locked
  • Question Question
Outputting a query to file rather than to the screen in Oracel 9i
Replies
3
Views
221
davehill1974
davehill1974
schintapalli
  • Locked
  • Question Question
avoiding sql query in output file
Replies
1
Views
169
vpshriyan
vpshriyan
chrono111
  • Locked
  • Question Question
Informix 9.3 problem w/decimal fields outputting scientific notation?
Replies
0
Views
87
chrono111
chrono111
TomBarrand
  • Locked
  • Question Question
Outputting query as xml
Replies
0
Views
84
TomBarrand
TomBarrand

Part and Inventory Search

Sponsor

Back
Top