Top "Cost-based-optimizer" questions

PostgreSQL - fetch the row which has the Max value for a column

I'm dealing with a Postgres table (called "lives") that contains records with columns for time_stamp, usr_id, transaction_id, …

sql postgresql query-optimization cbo cost-based-optimizer
sum over a list of tensors in tensorflow

I have a deep neural network where the weights between layers are stored in a list. layers[j].weights I …

python tensorflow cost-based-optimizer
Tensorflow cost function

I have an input dataset x with shape (10,1000), 10 inputs and 1000 lines and a output y with (1,1000), 1 output and 1000 lines. The …

python tensorflow deep-learning cost-based-optimizer
When does the Oracle CBO choose to execute a "merge join cartesian" operation?

From time to time, Oracle seems to prefer a MERGE JOIN CARTESIAN operation over a regular MERGE JOIN. Knowing the …

oracle optimization sql-execution-plan cartesian-product cost-based-optimizer