Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [recompile]

The tag has no usage guidance.

0
votes
2answers
55 views

Compile Dynamic Sql before Running

I have a table, and want to test if dynamic sql will compile. Example: create Table dbo.Product ( ProductId int, ProductName varchar(255) ) This will succeed: Column Name exists declare ...
1
vote
2answers
59 views

SQL Server Execution Plan on server level

Case: I have application which is doing search from database. That is going very slowly (more than 40 seconds). With trace I caught a query. When I run query in SSMS, it takes 2-3 seconds, but when I ...
1
vote
0answers
35 views

Oracle XML Database database invalid, how to validate/recompile … can i drop and recreate it. Please suggest

The installed components and their status, Oracle Database Catalog Views 12.1.0.2.0 Valid Oracle Database Packages and Types 12.1.0.2.0 Valid Oracle XML Database 12.1.0.2.0 ...
0
votes
0answers
36 views

Deferred Compile Event Subclass Meaning in SQL Profiler?

While tracing excessive recompilation (SQL:StmtRecompile) I found the main cause of it is 'Deferred Compile" as a event subclass. It is explained this way. Deferred compile occurs if an object ...