Thread: Re: [Squirrel-sql-users] Squirrel generates implicite statistics
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
From: Egli R. <Rol...@ai...> - 2008-06-16 06:01:05
|
Hi Rob I determine statistics on a table the following way: Before: select dba_tables.OWNER, table_name, last_analyzed from dba_tables where last_analyzed is not null -> No rows are selected I press the Objects-Tab in Squirrel for table 'ADR', afterwards the same statement returns OWNER TABLE_NAME LAST_ANALYZEDKONSUL ADR 2008-06-16 -> There exists a statistic on table ADR now. Roland___________________________________ My understanding of statistics is that you would need to change the data in some way for the statistics to change (assuming you don't drop them altogether). Merely querying data or metadata, shouldn't produce a change. The Info tab is populated from meta data that is "queried" by the JDBC driver. If the JDBC driver has a side effect that causes metadata or data to be changed in some way (thereby updating statistics) just by querying it, only Oracle would know. But other JDBC applications that use meta data would yield the same result. Can you explain how you determined that the statistics were updated? ( I'm hoping you can provide a reproducible list of steps that I can do on my own database to see the behavior you are describing) Rob On Fri, Jun 13, 2008 at 9:07 AM, Egli Roland <Rol...@ai...> wrote: Hi all We have recognized a problem using Squirrel with a Oracle DB: As soon as we go to Objects->Info on a table, Oracle creates statistics for this table. Is it possible to switch off this feature if it is any. Or is this a bug of Squirrel? Thanks in advance. The used version are: Squirrel: 2.6.5a Oracle: 8.1.7.0.1 JDBC-Driver: 10.2.0.1.0 Best regards Roland ------------------------------------------------------------------------- Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php _______________________________________________ Squirrel-sql-users mailing list Squ...@li... https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |