spool – Tarik Billa

Remove Column Header into the Output Text file

August 16, 2023 by Tarik

SQLPLUS COMMAND Skipped: set heading off That message is most likely because you are not executing it through SQL*Plus, but some GUI based tool. You are using SQLPlus command in SQL Developer. Not all SQL*Plus commands are guaranteed to work with SQL Developer. I would suggest you execute the script in SQLPlus and you would … Read more

Ways to avoid eager spool operations on SQL Server

August 3, 2023 by Tarik

My understanding of spooling is that it’s a bit of a red herring on your execution plan. Yes, it accounts for a lot of your query cost, but it’s actually an optimization that SQL Server undertakes automatically so that it can avoid costly rescanning. If you were to avoid spooling, the cost of the execution … Read more