Questions tagged [catalog-views]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
64 views

Query Over Oracle DB Link Requiring global_name = true

I'm running the following queries over a private dblink (Oracle Database 19c): delete from myschema.mytable@mydblink where SERVER = (select host_name from gv$instance); insert into myschema.mytable@...
-1 votes
2 answers
28 views

Find in what table I can find multiple collumns

I am trying to write a query that will show me the tables that contains all the following columns: ProductGroup, ProductClass and ProductID. But I am not very successful at it. Can somebody help me ...
0 votes
1 answer
44 views

Oracle: I drop a table, but select still show it

I see today a strange thing on my oracle db. SQL> select tablespace_name, table_name from user_tables; TABLESPACE_NAME |TABLE_NAME ----------------------------...
  • 183
0 votes
0 answers
95 views

mysql information_schema.columns missing data

i've a mysql 8.0.28 instance with a set of "broken" views. When i run this query mysql> select * from information_schema.columns where table_name = 'vw_accounts'; Empty set, 1 warning (0....
  • 1
0 votes
1 answer
121 views

Postgres query pg_views and pg_matviews taking a long time and finally error out

We have the following scheduled query which runs every 15 mins. select schemaname as schema_name, views.viewname view_name, views.definition from pg_catalog.pg_views ...
  • 135
0 votes
3 answers
287 views

How to select sys.views of another database from master databse?

I know I can get views metadata using sys.views system catalog view. But now I want to create a centralized function in my master database to be called from other databases. For example, I want to ...
  • 179
1 vote
0 answers
87 views

All columns of all views defined as "1" in phpmyadmin export

MySQL 5.7.24, phpmyadmin 4.8.3 phpMyAdmin appears to export corrupted definition on all views of one of my MySQL database. Eg: show create view v_contacts returns CREATE ALGORITHM=UNDEFINED DEFINER=`...
1 vote
1 answer
30 views

Not Auto and User Generated Stats in Catalog view of SQL Server

While querying select * from sys.stats I get this result In the Books Online it is written But looking at results I can see that there are also some stats which are not created neither ...
  • 2,078
0 votes
1 answer
125 views

Find out the number of rows/columns changed - SQL Server?

I found row/colmodctr options in sys.sysindexes but this has no equivalent in sys.indexes. Because sys.indexes is the recommended catalog view how can I find row and column change number without using ...
  • 2,078
11 votes
2 answers
1k views

What significance does an index_id < 256000 have?

In a certain tutorial I read the author is filtering sys.indexes based on the predicate index_id < 256000. What does this accomplish?
  • 7,180
0 votes
1 answer
1k views

USER_TAB_PARTITIONS Query Runs Incredibly Slow

I seem to be seeing incredibly slow (5-10 seconds) to run a query against USER_TAB_PARTITIONS (Oracle) intermittently. When I do an explain plan on : SELECT * FROM USER_TAB_PARTITIONS WHERE ...
  • 261