Search Results
https://dev.mysql.com/doc/internals/en/optimizer-union-queries.html
Therefore, for this query: SELECT * FROM Table1 WHERE column1 = 'x' UNION ALL SELECT * FROM TABLE1 WHERE column2 = 'y' if both column1 and column2 are indexed, then each SELECT is done using an indexed search, and the result sets are merged. Notice ...
https://dev.mysql.com/doc/internals/en/traceable-queries.html
They are: SELECT; INSERT or REPLACE (with VALUES or SELECT); UPDATE/DELETE and their multi-table variants; all the previous ones prefixed by EXPLAIN; SET (unless it manipulates the optimizer_trace system variable); DO; DECLARE/CASE/IF/RETURN ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-results-csv-json.html
You can use one of the following formats: https://namespace_name.objectstorage.region_name.oci.customer-oci.com/p/PAR_token/n/namespace_name/b/bucket_name/o/object_path ... This topic shows the different ways to export query results as a CSV file ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-results-parquet-json.html
end-object ] end-object' dialect_option: { {"format": "parquet" } | {"compression": {"uncompressed" | "snappy" | "gzip" | "brotli" | "zstd" | "lz4"} } } Parameter Descriptions for URI Supported as of MySQL 9.3.1. You can use one of the following ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-results-json-json.html
The option to export query results as an ND-JSON file is available as of MySQL 9.3.1. You can use one of the following formats: ...This topic shows the different ways to export query results as an ND-JSON file. INTO OUTFILE WITH PARAMETERS ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-results-json-non-json.html
Syntax: https://objectstorage.region_name.oraclecloud.com/n/namespace_name/b/bucket_name/o/prefixes Example: https://objectstorage.region1.oraclecloud.com/n/tenancy1/b/usr-bucket/o/summary/2024/Mar/ AWS S3 URL: Available for MySQL HeatWave on AWS.
https://dev.mysql.com/doc/refman/8.4/en/fulltext-query-expansion.html
For example, a user searching for “database” may really mean that “MySQL”, “Oracle”, “DB2”, and “RDBMS” all are phrases that should match “databases” and should be returned, too. Thus, if one of these documents contains the ... Full-text search supports query expansion (and in particular, its variant “blind query ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-permissions.html
mysql>GRANT EXPORT_QUERY_RESULTS ON database_name.* TO 'user_name'@'%'; The resource principal policy for Exporting Query Results to Object Storage. See Object Storage Pre-Authenticated Requests from Oracle Cloud Infrastructure Documentation to ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-installation-reference.html
Oracle Enterprise Manager for MySQL Database extends Oracle Enterprise Manager to enable monitoring of MySQL servers. Note Although Oracle Enterprise Manager for MySQL Database is based on MySQL Enterprise Monitor, it does not contain the following ...Download the plugin and deploy it on the OMS and Management Agent as described in the Oracle Enterprise Manager Cloud Control Administrator's ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-query-time-estimation.html
Auto Query Time Estimation can provide runtime data for up to 1000 queries, which is the MySQL HeatWave query history limit. Auto Query Time Estimation data is also available in JSON format or SQL table format with queries to the ... Auto Query Time ...This topic contains the following sections: Run Auto Query Time Estimation Auto Query Time Estimation Data Auto Query Time Estimation Examples What's Next Run Auto Query Time Estimation For Auto Query Time Estimation to provide runtime data, a query history must be ...