Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jayadev1
Starting Member
2 Posts |
 Posted - 2004-07-07 : 06:26:29
|
| hai all, i am working on a java application which has to store the statistics of a given query (like nodeid, totalsubtreecost etc) in a user table. is there a way for it? statistics that can be viewed in Query Analyzer by: (SET STATISTICS PROFILE ON ......<query> .......SET STATISTICS PROFILE OFF)(or showplan_all, showplan_text also) actually i have tried options like storing the statistics to a text file and then storing back to user table, but that needs to go to sql query analyzer and set the option to store to a file. also, i cannot use isql or DTS packages, since i am approaching from a java application.any suggestions? thanks in advancejayadev |
|
|
|
|
|
storing statistics in table?