hi all,

which sql query will be fast when run on the server..i am using sql query to get the data from the database and bind the data to the gridview.

Query1: select * from table

Query2: select * from table for xml raw

Query3: select * from table for xml auto.

Thanks in adance,

Ramesh Rathi.

Hi,

Set ShowPlan_All on

select * from [table]

select * from [table] for xml auto

 Hi,

  You can use Execution Plan to identify which is faster.

Please note that this queries will be used depending on the how you are going to utilize the output with in your front-end application.

Between XML Raw and XML Auto the different is only the xml structure, remaining behavior is same with both the clauses.

 

It will be faster if the data doesn't have to be converted to XML -- so query1 is best.  It returns a row set, which can be easily and efficiently bound to a gridview.