Timeline for UDF And Query Plan Caching
Current License: CC BY-SA 3.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 16, 2011 at 12:47 | vote | accept | Gavin | ||
| Nov 14, 2011 at 20:08 | comment | added | Mike Walsh | I would also run and output time statistics when you run this query. Run it specifying "SET STATISTICS TIME ON" before the query in that same session in SSMS. Paste the output here. | |
| Nov 14, 2011 at 16:31 | answer | added | gbn | timeline score: 2 | |
| Nov 14, 2011 at 15:57 | comment | added | Mike Walsh | Also - how much memory is your machine? How many rows are we talking returned for each execution? I'm thinking what @MartinSmith and JNK are thinking - data access more than query compilation. | |
| Nov 14, 2011 at 15:22 | answer | added | JNK | timeline score: 3 | |
| Nov 14, 2011 at 14:51 | comment | added | Martin Smith |
Will subsequent executions with different parameters likely need to read different data in from disc? What if you try DBCC DROPCLEANBUFFERS (on a development instance). Back to 5 seconds again?
|
|
| Nov 14, 2011 at 14:40 | history | asked | Gavin | CC BY-SA 3.0 |