Toad World® Forums

1,000 Record Limit on Profiles

Is there a way of Profiling more than 1,000 result records? In Data Point 5.1?

Only in the Professional Edition of TDP. Couple ways to do it...

  1. If you're in the Profiling tab of the Query Builder, for example, you'll see a hyperlink capability to perform data profiling for the entire results set, if desired, per first snap below.

  2. If you get into the Profiling Engine directly, you'll see the hyperlink to edit your Profiling options, per second snap below.

  3. Base edition will only get you profiling for the first 1,000 rows, so you'll need to find another way, probably via a SQL script.

Hope this helps.