Question : While answering this question https://stackoverflow.com/questions/4668146/how-to-add-a-primary-key-on-a-oracle-view/8558346#8558346 A lot of questions popped in my mind. 1. Is it advisable to […]
Tag: view
best practice for ‘staging’ relation in stored procedure: use temp table, or view?
Question : When I write stored procedures that take relation A and output relation Z, I like to create ‘staging’ […]
Question about Oracle’s interpretation of “host cpu utilization” in v$sysmetric view
Question : I am studying the v$sysmetric view from Oracle and trying to understand what is Oracle’s interpretation of “Host […]
MySQL – cannot examine view definition – Error getting DDL for object – No database selected
Question : I have a view that I can run, it returns a dataset, but whenever I try to alter […]
Can a view affect ALTER TABLE commands?
Question : I provide a database system to a number of customers. The database is installed locally on Oracle. We […]
View slow ONLY if requested in batches
Question : We have a view which includes a sub-query like this: SELECT id AS OrderNo, timestamp AS OrderDate, email, […]
Is there anything wrong with splitting a complicated view into many small ones?
Question : I have a view where each row is associated with a customer, and the columns are various computed […]
Simple view query takes a very long time
Question : Windows Server 2012, Microsoft SQL Server. I have a stored procedure (see below) that creates a view that […]
Window functions cause awful execution plan when called from a view with external parametrized ‘where’ clause
Question : I had this issue long time ago, I found a workaround which suited me and forgot about it. […]
SQL SERVER – Linked Server and query performance
Question : I have a performance problem related to SQL Server/linked servers/views. I hope you can help me understand what […]