IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

IWETHEY Home / IWETHEY Board / Theory and Practice of Programming Forum / I would ask for a showplan
Post #186,313
by Simon_Jester
12/7/04 5:25:51 PM
Reply
New I would ask for a showplan
or something similar..(can't remember what the oracle equiv is off-hand).

(Showplan is sybase)

Basically with a showplan, you give the database a query and then it tells you how it's going about getting the data (rather than actually going and getting the data).

This will determine if the problem is in the SQL query itself (ie: on the server) or in the transport mechanism (ie: the ODBC call).

I susppose that MS-SQL doesn't have an ISQL interface?
Post #186,332
by altmann
12/7/04 6:42:41 PM
12/7/04 6:43:59 PM
Reply
New There is an osql
and a SET SHOWPLAN_TEXT (or SHOWPLAN_ALL)

MSDE (what I assume is meant by "runtime") should have the osql CLI tool.

There's also a registry setting to turn plan logging on for the Jet engine that Access uses.

[link|http://builder.com.com/5100-6388-5064388.html|http://builder.com.c...6388-5064388.html]

[edit: removed restatment of your statement :)]
--
Chris Altmann
Expand Edited by altmann Dec. 7, 2004, 06:43:59 PM EST
Expand All History
     Why does something this simple, take soo long? - (folkert) - (21) - Dec. 7, 2004, 02:27:17 PM EST
         Probably at the Access level - (JayMehaffey) - (1) - Dec. 7, 2004, 03:10:19 PM EST
             Doesn't matter either way. - (folkert) - Dec. 7, 2004, 05:37:39 PM EST
         Investigate Pass-Through Queries in Access -NT - (altmann) - (1) - Dec. 7, 2004, 04:35:46 PM EST
             Thanks. I do that later. - (folkert) - Dec. 7, 2004, 05:39:12 PM EST
         Latency between Access and SQL Server - (ben_tilly) - (2) - Dec. 7, 2004, 05:13:12 PM EST
             That is just WRONG. - (folkert) - Dec. 7, 2004, 05:40:00 PM EST
             Sometimes faster just to import the whole table - (ChrisR) - Dec. 7, 2004, 05:53:08 PM EST
         I would ask for a showplan - (Simon_Jester) - (1) - Dec. 7, 2004, 05:25:51 PM EST
             There is an osql - (altmann) - Dec. 7, 2004, 06:43:59 PM EST
         The answer is in the first line of your post -NT - (tuberculosis) - (1) - Aug. 21, 2007, 06:34:31 AM EDT
             Clever, cleaver, thine art. -NT - (folkert) - Dec. 8, 2004, 01:02:49 PM EST
         Most questions that start, "why does Access......?" - (tablizer) - (9) - Dec. 22, 2004, 05:17:20 PM EST
             That might change. - (inthane-chan) - (8) - Dec. 22, 2004, 05:38:40 PM EST
                 Not unless VB is integrated with SQL server - (ben_tilly) - (7) - Dec. 22, 2004, 06:28:24 PM EST
                     Yeesh! - (inthane-chan) - (4) - Dec. 22, 2004, 06:47:37 PM EST
                         That trick is actually useful..ugly, but useful -NT - (ben_tilly) - (3) - Dec. 22, 2004, 07:50:13 PM EST
                             The poor man's Control Tables -NT - (ChrisR) - (2) - Dec. 22, 2004, 07:57:27 PM EST
                                 That's one thing to use it for -NT - (ben_tilly) - Dec. 22, 2004, 08:40:28 PM EST
                                 Files systems are not much better. Trees too damned limited -NT - (tablizer) - Dec. 26, 2004, 03:24:20 AM EST
                     Perish the thought - (ChrisR) - Dec. 22, 2004, 07:06:12 PM EST
                     "In the Next Version" - (altmann) - Dec. 22, 2004, 08:01:26 PM EST

Man... licensed to kill gophers.
59 ms