All Questions
7
questions
1
vote
1
answer
303
views
SQL Server hash match when joining to view
I have a subquery, which always return 1500 rows, because of TOP 1500 on the beginning. It gets left joined to a view, which returns 15mil rows if called outside any context. And in execution plan I'm ...
- 359
3
votes
1
answer
716
views
SQL Server Views | Inline View Expansion Guidelines
Background
Hello all!
I recently learned that in newer versions of SQL Server, the query optimizer can "expand" a SQL view and utilize inline performance benefits. This could have some ...
- 103
1
vote
0
answers
575
views
Auto Source to Target Column Mapping for Views - SQL Server
I am trying to map column sources to the alias given to the column in views. We have quite a few views and I want to dynamically map the column names in those views to their respective, I always ...
- 11
1
vote
0
answers
994
views
Oracle SQL - VIEW PUSHED PREDICATE not happening when using dblink
I'm having performance issues executing the following query (Q1):
select
z_out.*,
a_out.id
from orders a_out, test z_out
where a_out.id=z_out.id and a_out.created>trunc(sysdate) and rownum&...
- 23
0
votes
2
answers
138
views
ANSI_NULLS and QUOTED_IDENTIFIER Behavior
I have a view:
create view dbo.vMainTable
as
select MT.* from dbo.Table1 T1 with(index(dbo_Table1_UQ))
inner loop join dbo.MainTable MT with(index(dbo_MainTable_PK))
on T1.ID = MT.Table1_ID
go
On ...
- 1,640
3
votes
1
answer
524
views
SQL Server query through view and query through base tables get different execution plan
I have a view which is basically joining some tables and there are no indexes on the view. When I query against the view(joined with another table), the performance is bad, which takes about 10 ...
- 27.9k
2
votes
1
answer
304
views
Why do nested views have a different explain plan than a single merged view?
I have a view V2 that selects from another view V1 and adds a couple predicate filters.
V2 IS SELECT * FROM V1
WHERE ACTIVE='Y'
AND TYPE = '1';
When I do a join between V2 and a table FOO on the ...
- 8,871