Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [catalog-views]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
3 votes
2 answers
282 views

What are system_seeks in sys.dm_db_index_usage_stats?

The system view sys.dm_db_index_usage_stats has several columns reflecting usage of the index by system queries. But what does that mean? Why does the system query my table? The documentation is not ...
Yano_of_Queenscastle's user avatar
0 votes
1 answer
882 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@...
lightwing's user avatar
-1 votes
2 answers
42 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 ...
AnTiCoD's user avatar
0 votes
1 answer
92 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 ----------------------------...
elbarna's user avatar
  • 193
0 votes
0 answers
497 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....
vb-q's user avatar
  • 1
0 votes
1 answer
404 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 ...
sha's user avatar
  • 137
0 votes
3 answers
770 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 ...
Ali EXE's user avatar
  • 205
1 vote
0 answers
137 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=`...
Alexandre Avrane's user avatar
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 ...
igelr's user avatar
  • 2,132
0 votes
1 answer
167 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 ...
igelr's user avatar
  • 2,132
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?
usr's user avatar
  • 7,340
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 ...
GregH's user avatar
  • 279