Click here to Skip to main content
15,884,939 members
Home / Discussions / Database
   

Database

 
AnswerRe: CREATE INDEX Pin
Eddy Vluggen18-Jan-24 7:38
professionalEddy Vluggen18-Jan-24 7:38 
QuestionSQL behind the scenes Pin
mike741116-Jan-24 17:02
mike741116-Jan-24 17:02 
AnswerRe: SQL behind the scenes Pin
Richard MacCutchan16-Jan-24 21:54
mveRichard MacCutchan16-Jan-24 21:54 
AnswerRe: SQL behind the scenes Pin
Eddy Vluggen16-Jan-24 22:40
professionalEddy Vluggen16-Jan-24 22:40 
AnswerRe: SQL behind the scenes Pin
jschell17-Jan-24 4:29
jschell17-Jan-24 4:29 
AnswerRe: SQL behind the scenes Pin
RedDk17-Jan-24 8:30
RedDk17-Jan-24 8:30 
AnswerRe: SQL behind the scenes Pin
Eddy Vluggen18-Jan-24 7:33
professionalEddy Vluggen18-Jan-24 7:33 
GeneralRe: SQL behind the scenes Pin
jschell19-Jan-24 4:52
jschell19-Jan-24 4:52 
"index is sorted on col1, then col2. Meaning, col1 will be located first, then most rows following with the same col1 will be sorted on col2."

(My quote button still not working.)

Re-read that response after looking at post to other response.

That phrasing is a misstatement about how it works.

A table storage in a database is quite complicated. Often, but not always, records (rows) are inserted at the end of the table. Doesn't matter whether indexes exist or not. The reason for doing it that way is because it is faster.

There are some implementation details about how that works technically but 'at the end' is the best technical description. Clustered indexes do this differently but not specifically in terms of sorting anything.

After the insert the index(es) are updated. That involves storing some of the data from the row (columns in the index) and a pointer to the row itself.

Sorting is not something that is related to the table nor even to indexes. In SQL you can specifically ask for a specific sort order. If you do not do that then how the records (rows) are returned is somewhat random. And that becomes even more true when things like joins are factored in.
QuestionRe: SQL behind the scenes Pin
Eddy Vluggen10-Feb-24 10:08
professionalEddy Vluggen10-Feb-24 10:08 
QuestionSql Server Database goes into Recovery mode Pin
Nilesh M. Prajapati17-Nov-23 17:59
Nilesh M. Prajapati17-Nov-23 17:59 
AnswerRe: Sql Server Database goes into Recovery mode Pin
Andre Oosthuizen18-Nov-23 7:35
mveAndre Oosthuizen18-Nov-23 7:35 
AnswerRe: Sql Server Database goes into Recovery mode Pin
Mycroft Holmes18-Nov-23 11:38
professionalMycroft Holmes18-Nov-23 11:38 
AnswerRe: Sql Server Database goes into Recovery mode Pin
CHill6020-Nov-23 4:10
mveCHill6020-Nov-23 4:10 
AnswerRe: Sql Server Database goes into Recovery mode Pin
jschell20-Nov-23 7:48
jschell20-Nov-23 7:48 
QuestionSQLite Thread Safety Pin
Richard Andrew x6410-Nov-23 12:23
professionalRichard Andrew x6410-Nov-23 12:23 
AnswerRe: SQLite Thread Safety Pin
Gerry Schmitz10-Nov-23 14:04
mveGerry Schmitz10-Nov-23 14:04 
GeneralRe: SQLite Thread Safety Pin
Richard Andrew x6410-Nov-23 15:33
professionalRichard Andrew x6410-Nov-23 15:33 
GeneralRe: SQLite Thread Safety Pin
Gerry Schmitz13-Nov-23 11:14
mveGerry Schmitz13-Nov-23 11:14 
AnswerRe: SQLite Thread Safety Pin
Jörgen Andersson12-Nov-23 21:16
professionalJörgen Andersson12-Nov-23 21:16 
QuestionSQLite syntax error that I can't figure out - SOLVED Pin
Richard Andrew x644-Nov-23 14:09
professionalRichard Andrew x644-Nov-23 14:09 
AnswerRe: SQLite syntax error that I can't figure out Pin
k50544-Nov-23 17:22
mvek50544-Nov-23 17:22 
GeneralRe: SQLite syntax error that I can't figure out Pin
Richard Andrew x645-Nov-23 1:57
professionalRichard Andrew x645-Nov-23 1:57 
Questionplease Pin
daw htikehtike21-Oct-23 19:17
daw htikehtike21-Oct-23 19:17 
AnswerRe: please Pin
Richard MacCutchan21-Oct-23 21:14
mveRichard MacCutchan21-Oct-23 21:14 
AnswerRe: please Pin
jschell23-Oct-23 5:25
jschell23-Oct-23 5:25 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.