# The new Analyze Objects window

**URL:** <https://forums.toadworld.com/t/the-new-analyze-objects-window/50186>\
**Category:** Idea Pond\
**Created:** [June 25, 2020, 5:57pm UTC](https://forums.toadworld.com/t/the-new-analyze-objects-window/50186 "2020-06-25T17:57:33Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![brian.keegan](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/brian.keegan/32/206_2.png) [@brian.keegan](https://forums.toadworld.com/u/brian.keegan)\
**Post date:** [June 25, 2020, 5:57pm UTC](https://forums.toadworld.com/t/the-new-analyze-objects-window/50186/1 "2020-06-25T17:57:33Z")

</div>

Hi all,

I just got to upgrade to version 13.3 (commercial) and found the Analyze Objects that replaced the Analyze All window.

I would propose that the left and right hand panels be resizable. When running a List job the right hand Output panel is quite narrow. The first time I ran it I got a list of partitioned tables and I could only see the schema name and part of the table name in the Output panel.

I also miss the ability to choose from the list which tables or partitions I might want analyzed without doing the entire list. In my case the list contained several tables with many partitions comprising billions of rows of data. Sending it off to do the whole schema would have entailed running for a day or two. I could note which ones I want to do and then go choose them from the SB but it would be easier to mark them and do it in place.

I know these are separate items and the first would really be handy and I hope be an easier alteration to do compared to the second.

Thanks as always,  
Brian Keegan

Toad for Oracle version commercial 13.3.0.181  
Oracle 12.2 enterprise  
Oracle client 12.1  
Everything 64-bit running on 64-bit Windows 10  
No legacy Toad restrictions in place

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [June 29, 2020, 1:24pm UTC](https://forums.toadworld.com/t/the-new-analyze-objects-window/50186/2 "2020-06-29T13:24:41Z")

</div>

Hey Brian,

Thanks for the feedback. Can you give me a screen shot showing what you'd like to be able to resize? I thought I made resizing available everywhere it made sense so I'm not sure what you want to resize.

As for choosing which objects to analyze, you can still do that. By deleting the objects from the list that you don't want to analyze. If there are a group of items that you want to analyze and you want to no analyze the rest, the easiest thing to do is select the ones that you want to keep, then click the dropdown next to the "delete" toolbar button, then click "all except selected" under it.

I do see a little room for improvement, maybe on the last step, the columns could be sized automatically for the text.

See below, let me know if I'm missing something.

 ![AnalyzeObjects](https://global.discourse-cdn.com/quest/original/2X/d/dcbd9d580193577afa68eae1360728c0c0c5bffc.gif)

Thanks,

-John

---

<div class="post-metadata">

**Author:** ![brian.keegan](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/brian.keegan/32/206_2.png) [@brian.keegan](https://forums.toadworld.com/u/brian.keegan)\
**Post date:** [June 29, 2020, 4:51pm UTC](https://forums.toadworld.com/t/the-new-analyze-objects-window/50186/3 "2020-06-29T16:51:26Z")

</div>

Hi John,

Here’s the screen shot. The Output section on the right can’t be widened as far as I see. It came to this screen by choosing “List Auto” under Choose Options. No horizontal scroll bar or preferably the ability to grab the edge and enlarge it at the cost of the RHS. Being able to widen it would allow seeing the table name and partition where applicable. Being able to, in some way, pick what you wanted to analyze from the Output list would be a great bonus if there isn’t a way now. I see that I could go from here to where your screen shot came from to fine tune the stats run so that can work.

In the old versions there hadn’t been an output at all and when I asked for that you all did an amazing job of adding that and great functionalities.

 ![image001.png](https://global.discourse-cdn.com/quest/original/2X/9/98c8c4fb4ce4d2a2cbc1afc5af44ebbf9ed3348a.png)

![image002.png](https://global.discourse-cdn.com/quest/original/2X/d/d9cdfe9d25701aa8374f18008d0c0dc96fa7c38a.png)

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [June 29, 2020, 4:53pm UTC](https://forums.toadworld.com/t/the-new-analyze-objects-window/50186/4 "2020-06-29T16:53:39Z")

</div>

Oh, that one. Forgot about the output option. Yeah it does need a splitter. I'll take care of it.

---

<div class="post-metadata">

**Author:** ![brian.keegan](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/brian.keegan/32/206_2.png) [@brian.keegan](https://forums.toadworld.com/u/brian.keegan)\
**Post date:** [June 29, 2020, 5:51pm UTC](https://forums.toadworld.com/t/the-new-analyze-objects-window/50186/5 "2020-06-29T17:51:53Z")

</div>

Thank you as always. You all are the best team in the business.

![image002.png](https://global.discourse-cdn.com/quest/original/2X/d/d9cdfe9d25701aa8374f18008d0c0dc96fa7c38a.png)

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [June 29, 2020, 6:16pm UTC](https://forums.toadworld.com/t/the-new-analyze-objects-window/50186/6 "2020-06-29T18:16:21Z")

</div>

Thanks Brian!

BTW, I forgot, if you want to just select certain objects to analyze, similar to the way you did before, you can do this:

 ![AnalyzeObjects2](https://global.discourse-cdn.com/quest/original/2X/8/8030937cc2c0e0eb628fd435cb47c8e4a44c16ea.gif)

> [@brian.keegan](#):
>
> Being able to, in some way, pick what you wanted to analyze from the Output list would be a great bonus if there isn’t a way now.

There's no way to do that now...did you want to select and then just rt-click-\>Gather Stats on those objects? Or send those objects to the first step?
