Questions about sql-execution-plan
Read more about sql-execution-plan
python (12.9k questions)
javascript (9.2k questions)
reactjs (4.7k questions)
java (4.2k questions)
java (4.2k questions)
c# (3.5k questions)
c# (3.5k questions)
html (3.3k questions)
Why INSERT query is 3-4 times slower than SELECT?
Application talks to YugabyteDB instance with YCQL driver(Gocql).
We have below two queries (for example):
SELECT col2,
col3,
col4,
col5
FROM table1
WHERE primarykeycol = 11ab8...
overexchange
Votes: 0
Answers: 2
Is any performance enhancement when we used Unique index instead of non Unique index?
I know a unique index will be faster than a non unique index theoretically if data is unique.
Because a unique index is able to provide more information and let the query optimizer choose more effecti...
D-Shih
Votes: 0
Answers: 1
Will Entity Framework Clear Query Plans in the Cache that it, itself, did not create?
We are looking to switch to EF for some of our new applications, and our Database Team has raised concerns about this particular, documented function of the Query Plan Cleanup operation of Entity Fram...
SurelyTheresABetterWay
Votes: 0
Answers: 0
Using Machine Learning for generating Query Execution Plan
I am aware of cost based and rule based optimizers ? Are there any Query engines that use Machine Learning (based on similar queries run in the past) for generating Query execution plans ?
SeaGoat
Votes: 0
Answers: 0