All Questions
7
questions
3
votes
2
answers
446
views
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 = ...
0
votes
1
answer
3k
views
Different execution plan for the same query
I have two identical SQL Databases that contain nearly the same records in each of their tables. The only difference between them is that one lives on my local machine and the other one is in Azure. ...
- 195
0
votes
1
answer
894
views
Comparing stored procedure execution plan at different queries
When I compare execution plans of stored procedures, it only does the first one. I want to compare query 3 which is the main SP but I just am not able to. Is there a way to do this in SQL Server ...
- 24.1k
2
votes
1
answer
15k
views
Possible to disable an SQL execution plan in Oracle?
I have a situation where Oracle creates multiple execution plans for a given query. Most of the time, it chooses a certain one that performs quite well. Sometimes, however, it chooses one that ...
- 9,519
-1
votes
2
answers
87
views
More Efficient Union Statement Than This?
I'm trying to wire up some generic search results, and would like it to perform as well as I could possibly make it happen. It's not terrible right now, but I feel like I could potentially improve ...
9
votes
1
answer
6k
views
How reliable is the cost measurement in PostgreSQL Explain Plan?
The queries are performed on a large table with 11 million rows. I have already performed an ANALYZE on the table prior to the query executions.
Query 1:
SELECT *
FROM accounts t1
LEFT OUTER JOIN ...
- 9,773
18
votes
2
answers
22k
views
Why is Oracle ignoring index with ORDER BY?
My intention is to obtain a paginated resultset of customers. I am using this algorithm, from Tom:
select * from (
select /*+ FIRST_ROWS(20) */ FIRST_NAME, ROW_NUMBER() over (order by FIRST_NAME) ...
- 255