You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "linqr (via GitHub)" <gi...@apache.org> on 2023/07/13 01:34:13 UTC
[GitHub] [shardingsphere] linqr opened a new issue, #26931: ORACLE- getIndexInfo is slow，because analyze table compute statistics，can i send the “true” param to getIndexInfo method？
linqr opened a new issue, #26931:
URL: https://github.com/apache/shardingsphere/issues/26931
Which version of ShardingSphere did you use?
5.1.1
Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
ShardingSphere-JDBC
Expected behavior
Start my app as soon as possible，can i send the “true” param to getIndexInfo，close the analyze；
Actual behavior
Load meta data for schema logic_db finished, cost 30 minutter
Reason analyze (If you can)
the method getIndexInfo() in jdbc has 5 param，the 5th param approximate,
when true, result is allowed to reflect approximate or out of data values;
when false, results are requested to be accurate，in the oracle jdbc implment,
if approximate is false, it will analyze table compute statistics, the table records over 10 million，table compute statistics cost too much time, DBAs have their own plans to analyze table compute statistics, so, the param approximate can configure in the rule configuration file?
public static Collection load(final Connection connection, final String table) throws SQLException {
Collection result = new HashSet<>();
try (ResultSet resultSet = connection.getMetaData().getIndexInfo(connection.getCatalog(), connection.getSchema(), table, false, false)) {
while (resultSet.next()) {
String indexName = resultSet.getString(INDEX_NAME);
if (null != indexName) {
result.add(new PhysicalIndexMetaData(indexName));
}
}
}
return result;
}
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] ORACLE- getIndexInfo is slow，because analyze table compute statistics，can i send the “true” param to getIndexInfo method？ [shardingsphere]
Posted by "terrymanu (via GitHub)" <gi...@apache.org>.
terrymanu commented on issue #26931:
URL: https://github.com/apache/shardingsphere/issues/26931#issuecomment-2230749683
The metadata is improved in each version, can you test the latest version?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] ORACLE- getIndexInfo is slow，because analyze table compute statistics，can i send the “true” param to getIndexInfo method？ [shardingsphere]
Posted by "terrymanu (via GitHub)" <gi...@apache.org>.
terrymanu closed issue #26931: ORACLE- getIndexInfo is slow，because analyze table compute statistics，can i send the “true” param to getIndexInfo method？
URL: https://github.com/apache/shardingsphere/issues/26931
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] github-actions[bot] commented on issue #26931: ORACLE- getIndexInfo is slow，because analyze table compute statistics，can i send the “true” param to getIndexInfo method？
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #26931:
URL: https://github.com/apache/shardingsphere/issues/26931#issuecomment-1682904213
There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] ORACLE- getIndexInfo is slow，because analyze table compute statistics，can i send the “true” param to getIndexInfo method？ [shardingsphere]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #26931:
URL: https://github.com/apache/shardingsphere/issues/26931#issuecomment-2259120351
There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org