Question : I’m learning how column-oriented DBMS / “columnars” work for OLAP situations. Let’s say we have a log of […]
Tag: scan
Delete cascade produce scan intead of index seek
Question : I have two tables in my database. TableA : 1427877 rows TableB : 339939000 rows TableB has a […]
MSSQL Join between big and empty tables
Question : I’ve got an issue with estimated cost and join predicate : SELECT c.Id FROM Table_A a LEFT JOIN […]
SCAN listener redirects connection to another port
Question : I have setup RAC. I have two listeners LISTENER and LISTENER_DG. LISTENER is listening port 1521 LISTENER_DG is […]
MSSQL Join between big and empty tables
Question : I’ve got an issue with estimated cost and join predicate : SELECT c.Id FROM Table_A a LEFT JOIN […]
Very high (99%) insertion cost in estimated execution plan
Question : I have four tables with 500,000 to 4,000,000 rows. The script joins them and insert into a temporary […]
Vulnerability in Server from SQL Server 2008 R2
Question : We scanned our systems and got a high vulnerability reported in a server. One of the thing that […]