SET vs. SELECT – What’s the difference?

by

SET is the ANSI standard way of assigning values to variables, and SELECT is not. But you can use SELECT to assign values to more than one variable at a time. SET allows you to assign data to only one variable at a time. So that in performance is where SELECT will be a winner.

For more detail and examples refer to: Difference between SET and SELECT when assigning values to variables

Related Contents:

  1. Why is appending to a list bad?
  2. When should I use CROSS APPLY over INNER JOIN?
  3. Performance optimization strategies of last resort [closed]
  4. What’s the most efficient way to test if two ranges overlap?
  5. Is it safe to shallow clone with –depth 1, create commits, and pull updates again?
  6. Why JSF calls getters multiple times
  7. How to find the kth largest element in an unsorted array of length n in O(n)?
  8. postgresql COUNT(DISTINCT …) very slow
  9. SQL JOIN vs IN performance?
  10. Approximate cost to access various caches and main memory?
  11. Speed up the loop operation in R
  12. Why is MATLAB so fast in matrix multiplication?
  13. What is considered a good response time for a dynamic, personalized web application? [closed]
  14. Has anyone actually implemented a Fibonacci-Heap efficiently?
  15. Multiple INSERT statements vs. single INSERT with multiple VALUES
  16. What is the difference between spark.sql.shuffle.partitions and spark.default.parallelism?
  17. How to analyze golang memory?
  18. atomic operation cost
  19. Why is vectorization, faster in general, than loops?
  20. If registers are so blazingly fast, why don’t we have more of them?
  21. React Navigation vs. React Native Navigation [closed]
  22. FreeBSD performance tuning: Sysctl parameter, loader.conf, kernel
  23. To improve SQL performance, why not just put lots of RAM rather than having faster hard disks?
  24. What does “low profile” stand for, connected to hardware?
  25. Performance difference between compiled and binary linux distributions/packages
  26. Which bots and spiders should I block in robots.txt?
  27. First days online : how not to kill your site
  28. Is calculating IOPS for ZFS RAIDZ different then calculating IOPS for RAID5 & RAID6?
  29. Why is FileZilla so much faster than PSFTP?
  30. What’s the fastest filesystem for developer builds?
  31. pg_restore taking much longer than pg_dump
  32. PostgreSQL temporary tables
  33. Performance of bcp/BULK INSERT vs. Table-Valued Parameters
  34. Fast query runs slow in SSRS
  35. Jmeter alternative [closed]
  36. LOWER LIKE vs iLIKE
  37. translate3d vs translate performance
  38. Performance tips for making Visual Studio 2010 faster? [closed]
  39. what does O(N) mean [duplicate]
  40. Why is Solr so much faster than Postgres?
  41. Most Efficient Way to Create an Index in Postgres
  42. Why when I transfer a file through SFTP, it takes longer than FTP?
  43. MongoDB ‘count()’ is very slow. How do we refine/work around with it?
  44. Faster way to initialize arrays via empty matrix multiplication? (Matlab)
  45. Why is this SSE code 6 times slower without VZEROUPPER on Skylake?
  46. How are cache memories shared in multicore Intel CPUs?
  47. preallocate list in R
  48. JMeter understanding ramp-up
  49. Improving Postgres psycopg2 query performance for Python to the same level of Java’s JDBC driver
  50. What is the difference between latency, bandwidth and throughput?

Leave a Comment