There is an osql

IWETHEY v. 0.3.0 | TODO

1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User

Welcome to IWETHEY!

Post #186,332

by altmann

12/7/04 6:42:41 PM

12/7/04 6:43:59 PM

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

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

iwethey.org

'Cause the music rules.
44 ms