|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
November 19th, 2003, 03:17 AM
|
|||
|
|||
|
Optimizing SQL queries using MS ACCESS
Hi All
I am a new member here I am working on tuning of SQL queries using MS Access database I really dunno know how to check whether ur query has been optimized or not. Say suppose I altered one query and ran it again, how will i come to know the difference in terms of optimization. If possible , please suggest some website Thanx Vik
|
|
#2
November 19th, 2003, 04:44 AM
|
|||
|
|||
|
http://support.microsoft.com/defaul...b;en-us;q112112
http://support.microsoft.com/?kbid=209126 http://www.advent-it.co.uk/queryop.html Tools like SQL Profiler(SQL Server) and TOAD(Oracle) are not made for MS Access. The best way is to learn the optimization rule for your query. If you're truely want to 'optimize' your database, use a database server software.
|
|
| Viewing: Dev Shed Forums > Databases > Database Management > Optimizing SQL queries using MS ACCESS |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
