Menu
Ive always wondered this but never had the chance to research it.
What sort of algorithms are use in SQL? Naturally you search and compare for basic statements, what search algorithms? Sorting? and for other functions like Join's etc.
I know there is no clear cut answer to this questions but the idea is to gather a general idea of what sort of methods SQL uses to carry out its work.
737
SQL Server allows administrators and developers to choose from among several algorithms, including DES, Triple DES, TRIPLE_DES_3KEY, RC2, RC4, 128-bit RC4, DESX, 128-bit AES, 192-bit AES, and 256-bit AES. Beginning with SQL Server 2016 (13. x), all algorithms other than AES_128, AES_192, and AES_256 are deprecated.
CLOSE leaves the data structures available for reopening, but fetches and positioned updates are not allowed until the cursor is reopened. CLOSE must be issued on an open cursor; CLOSE is not allowed on cursors that have only been declared or are already closed.
The Linear Search and the Binary Search are the examples of Searching Algorithms. The Bubble Sort, Insertion Sort, Selection Sort, Merge Sort, Quick Sort etc are the examples of Sorting Algorithms.
what is php😐? s sql is an algorithimic language but there is a lots of queries and as a alg there is a such type of procedure in writing the queries and languages and certain constraints can be applied for that.
I would suggest you get a copy of SQL Server 2008 Internals by Delaney, Randal, Tripp and more. Excellent book on the internal workings of SQL Server.
http://www.amazon.com/Microsoft-SQL-Server-2008-Internals/dp/0735626243/ref=sr_1_1?s=books&ie=UTF8&qid=1289565465&sr=1-1
89
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
