I have to query 100 s of table for their count.the tables are huge and the time it takes is too high. Since i am not always connected with my client , i want an alternative to spooling .i.e. I want run my .sql file
and want to see those count , the next day .I can access the db from a remote client only .Whats the best way to capture those counts .Does the server kills my .sql file once i disconnect the client ? If not, can i insert them into a table .Is their any alternative to this.