Question:

SELECT top 1 * FROM Table order by newID, Can any one can optimize this query.

by Guest21705957  |  1 year, 6 month(s) ago

0 LIKES UnLike

I Have more then 15,00,000 records in database and the above query perform very slow

 Tags: newid, optimize, query, select, table, top

   Report
Answer The Question I've Same Question Too
CAN YOU ANSWER?
You're reading: SELECT top 1 * FROM Table order by newID, Can any one can optimize this query.

Question Stats

Latest activity: 1 year, 6 month(s) ago.
This question has been viewed 214 times and has 0 answers.

BECOME A GUIDE

Share your knowledge and help people by answering questions.
Register Now