# Analyze table **URL:** \ **Category:** Toad Data Point & Toad Intelligence Central\ **Created:** [January 10, 2008, 8:23am UTC](https://forums.toadworld.com/t/analyze-table/5798 "2008-01-10T08:23:08Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![MissM](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/missm/32/108_2.png) [@MissM](https://forums.toadworld.com/u/MissM)\ **Post date:** [January 10, 2008, 8:23am UTC](https://forums.toadworld.com/t/analyze-table/5798/1 "2008-01-10T08:23:08Z")
Hi! I can’t find the ‘analyze table’ icon. And if I select table and do the ‘ctrl+F10+N’ trick - as suggested in HELP, I get the ‘Notes’ window. Any advice? Thanks! M ---
**Author:** ![jacquesrk](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/jacquesrk/32/107_2.png) [@jacquesrk](https://forums.toadworld.com/u/jacquesrk)\ **Post date:** [January 10, 2008, 11:54am UTC](https://forums.toadworld.com/t/analyze-table/5798/2 "2008-01-10T11:54:07Z")
I’m sorry, but in this case the Help has incorrect information. To analyze a table in Toad for Data Analysis, you would need to go to an Editor window and type in the .SQL command. Would you be interested in an enhancement request to allow tables to be analyzed using a button or a menu command? P.S. Which RDBMS are you using? ---
**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\ **Post date:** [January 10, 2008, 2:26pm UTC](https://forums.toadworld.com/t/analyze-table/5798/3 "2008-01-10T14:26:47Z")
Analyzing a table usually is a DBA task. Is this something you do often? And on what platform? Oracle, DB2? Also, can you briefly share how you are using Toad for Data Analyst? IE: Creating reports from Ad hoc requests. Importing data from warehouse and querying on local tables. ETC. This helps us to understand your use case and request. Debbie ---
**Author:** ![MissM](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/missm/32/108_2.png) [@MissM](https://forums.toadworld.com/u/MissM)\ **Post date:** [January 11, 2008, 2:09am UTC](https://forums.toadworld.com/t/analyze-table/5798/4 "2008-01-11T02:09:30Z")
Hello! Thank you for this. I solved my problem ‘old school’ style anyway. I was just a bit surprised that I could not do, nor find, what Help suggested. I added a doc with help print-screen to this post. I just got my TOAD we are in ‘getting-to-know-eachother’ phase right now. If there was a button or a menu command as planed (I guess ) - it would certainly be a nice feature. There were a couple of other things regarding tables that are described in Help and I could not find them in my TOAD - like Check tables. We are using Oracle 10g. [analyze tables.doc](https://global.discourse-cdn.com/quest/original/2X/0/0aef8a99abfac938dfbb9f6635169dbca415c65f.doc) (74 KB) ---
**Author:** ![MissM](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/missm/32/108_2.png) [@MissM](https://forums.toadworld.com/u/MissM)\ **Post date:** [January 11, 2008, 2:34am UTC](https://forums.toadworld.com/t/analyze-table/5798/5 "2008-01-11T02:34:48Z")
Hi! As I mentioned before, we’re using Oracle (10g) platform. I use TOAD mainly for creating tables, and then preforming all sorts of queries on them. I need to analyze created table, because statistics are not calculated by default - and just by analzing them - all my later actions (queries) are sooooooo much faster. There is another thing. I have TOAD for a month or so now, and sometimes it just closes. It happend three times in a month - last was yesterday. It closed without any ‘Do you want to save changes?’ or ‘Do you want to commit changes?’ - nothing. It just disappeard. I had about 5 editors opend - something saved, but not all. I know about shift+F8 (recall sql statement window), but I had written comments and some SQLs which I didn’t run jet as well, and they were all gone. It took me quite some time to rewrite. Is this closeing thing a ‘bug’ and does it happen often? Anybody else reported it? Thanks, M ---
**Author:** ![jacquesrk](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/jacquesrk/32/107_2.png) [@jacquesrk](https://forums.toadworld.com/u/jacquesrk)\ **Post date:** [January 11, 2008, 12:29pm UTC](https://forums.toadworld.com/t/analyze-table/5798/6 "2008-01-11T12:29:36Z")
Hello, we have a current bug report to correct the documentation because we are aware that there are several places in the Help where we mention features that are not available in the product (such as Analyze Tables or Check Tables). Toad for Data Analysis is an analyst tool, not a DBA tool, and so for simplicity’s sake some of the functionality present in our DBA Toad products is not present in Toad for Data Analysis. However we are always looking for customer feedback to see how picture are using the product. If you come across some other features (aside from Analyze Table) that you would like to see added to the product, please let us know. ---
**Author:** ![jacquesrk](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/jacquesrk/32/107_2.png) [@jacquesrk](https://forums.toadworld.com/u/jacquesrk)\ **Post date:** [January 11, 2008, 12:31pm UTC](https://forums.toadworld.com/t/analyze-table/5798/7 "2008-01-11T12:31:45Z")
Closing without any warning or prompt to save files would definitely be a bug. I don’t recall anyone else reporting it. Where all the open windows connected to the same Oracle database? How long had the application been open? Do you remember what action you took just prior to the application closing? ---
**Author:** ![jacquesrk](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/jacquesrk/32/107_2.png) [@jacquesrk](https://forums.toadworld.com/u/jacquesrk)\ **Post date:** [January 11, 2008, 5:26pm UTC](https://forums.toadworld.com/t/analyze-table/5798/8 "2008-01-11T17:26:25Z")
Another question, related to the issue of Toad just closing while you are using it - are you running Toad for Data Analysis 1.1.0.328? This is the latest version available and we recommend upgrading because it has some bug fixes (that may or may not solve your problem.) Also, could you please send us a support bundle? (Choose the Support Bundle option in the Help Menu) Thank you. ---
**Author:** ![MissM](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/missm/32/108_2.png) [@MissM](https://forums.toadworld.com/u/MissM)\ **Post date:** [January 12, 2008, 11:18am UTC](https://forums.toadworld.com/t/analyze-table/5798/9 "2008-01-12T11:18:36Z")
As you just mentioned what feature would I like to have… I really, really miss the **autosave** feature for editor. I often write comments with my SQLs, and if something happens and you don’t manage to save your work - everything is lost. I like ‘recall sql’ feature though. But it doesn’t work with SQLs that weren’t run and comments. ---
**Author:** ![MissM](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/missm/32/108_2.png) [@MissM](https://forums.toadworld.com/u/MissM)\ **Post date:** [January 12, 2008, 11:33am UTC](https://forums.toadworld.com/t/analyze-table/5798/10 "2008-01-12T11:33:28Z")
When my TOAD closed, I was connected to two Oracle databases and application was opened for aprox. 10 hrs. I wasn’t doing anything. A query that I run was complete - while it was running I was doing something else in some other application. Then I clicked back to toad to go over results … I basicly just ‘alt+tab’-ed back, been there, wanted to save stuff I had in my editor, so I think I hit ‘ctrl+s’ and it vanished. Or at least I wanted to hit ctrl+s. ---
**Author:** ![jacquesrk](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/jacquesrk/32/107_2.png) [@jacquesrk](https://forums.toadworld.com/u/jacquesrk)\ **Post date:** [January 14, 2008, 12:53pm UTC](https://forums.toadworld.com/t/analyze-table/5798/11 "2008-01-14T12:53:26Z")
That sounds like a reasonable request. I have created Quest Internal change request 43986 to add “autosave” functionality to the editor for Toad for Data Analysis. Thank you for your feedback! ---
**Author:** ![jacquesrk](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/jacquesrk/32/107_2.png) [@jacquesrk](https://forums.toadworld.com/u/jacquesrk)\ **Post date:** [January 14, 2008, 12:55pm UTC](https://forums.toadworld.com/t/analyze-table/5798/12 "2008-01-14T12:55:57Z")
Concerning the other issue, Toad just closing on you - I will try it myself, leave some windows open for a few hours, and then switch back and try to save the editor window, to see if I have the same problem. ---
**Author:** ![MissM](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/missm/32/108_2.png) [@MissM](https://forums.toadworld.com/u/MissM)\ **Post date:** [January 14, 2008, 3:23pm UTC](https://forums.toadworld.com/t/analyze-table/5798/13 "2008-01-14T15:23:51Z")
Thanks, M jacquesrk wrote: That sounds like a reasonable request. I have created Quest Internal change request 43986 to add “autosave” functionality to the editor for Toad for Data Analysis. Thank you for your feedback! ---
**Author:** ![MissM](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/missm/32/108_2.png) [@MissM](https://forums.toadworld.com/u/MissM)\ **Post date:** [January 14, 2008, 3:27pm UTC](https://forums.toadworld.com/t/analyze-table/5798/14 "2008-01-14T15:27:40Z")
Jp, running on 1.1.0.328 and did send support bundle. Thank you guys for all your effort. Really, really kind of you. M jacquesrk wrote: Another question, related to the issue of Toad just closing while you are using it - are you running Toad for Data Analysis 1.1.0.328? This is the latest version available and we recommend upgrading because it has some bug fixes (that may or may not solve your problem.) Also, could you please send us a support bundle? (Choose the Support Bundle option in the Help Menu)