I am troubleshooting this slow stored procedure and when checking the actual execution plan I noticed a warning of a possible missing index. Taking a closer look, it's against one of the views, not an ...

I have created a teiid vdb with sql server data source.
The view model contains a materialized view, how to refresh the materialized view manually or automatically? Is there any sql command to trigger ...

I have setup a few buckets and now I’d like to create a view but I’m not sure where to start. I have logged in to the web console but the views I have created to not return any results. Also, is it ...

We have a number of tables (about 40) with approximately 2500 columns between them that all have matching primary keys, but different unique columns. For various procedures and views, we'll draw on ...

In my Oracle database, I have a number of schemas (users/owners) with similar table structures (about 100 in total). However, some tables are empty in a lot of schemas. Is there a way to find out for ...

I am using mysql 5.6, I am not being able to create materialized view here like oracle. I got one or two solution like flexview and all...
Can anybody tell me best way to create materialized view in ...

I have a table private.products and a view public.products representing that table. And I want to create entries in private.products while inserting into view, it all works right, except that I also ...

I have a view and it's a left join between two tables (table_a has hundreds of millions of rows, table_b has ~2 millions). The query
SELECT MIN("id") AS "min_id",MAX("id") AS "max_id" FROM "the_view" ...

I have a data warehouse with a lot of views built in with the SSMS view designer.
Viewing the syntax, the FROM clauses are unintelligible to me because the ON statements do not follow straight after ...

We are using oracle 11g
I am replicating production db for dev environment.
I Have a user named CST2 and CST0 where CST0 contains all tables and view and public synonyms for the same. I have provided ...

For various corporate and historical and replicating reasons, I have multiple databases that contain similar-structured tables, holding the main production data used as a source for other home-made ...

I am DBA of server A (SQL Server 2008R2), linked to server B (SQL Server 2012SP1), linked to server C (not sure which version).
I have no control on server C, and I cannot contact its DBA.
On server ...

I have a view which involves LEFT JOINS on 20+ tables to a base table but when querying this view and looking at the execution plans I am getting something totally unexpected.
For example, with the ...

How can I create something similar to VIEW or TEMPORARY TABLE for every query separately?
I have 1 process, it creates and holds one connection (doesn't destroy connection after request, so doesn't ...

I have a VIEW where I'm attempting to create an evolution script for, so I can add a column to it. That part works fine; column added just fine. However, the reverse does not work; remove that last ...

We've been browsing for a while looking for an answer to this, but any of them suited exactly my needs, I hope is a relevant question.
We have a database for managing books. In this database, a same ...