Click here to Skip to main content
14,669,501 members
Home » Discussions » Database
   

Database

 
AnswerRe: Create a new Primary Key on survey table Pin
David Mujica2-Mar-20 3:56
MemberDavid Mujica2-Mar-20 3:56 
GeneralRe: Create a new Primary Key on survey table Pin
learning_new3-Mar-20 4:28
Memberlearning_new3-Mar-20 4:28 
QuestionIndexing question Pin
Super Lloyd5-Feb-20 13:35
MemberSuper Lloyd5-Feb-20 13:35 
AnswerRe: Indexing question Pin
Eddy Vluggen5-Feb-20 15:09
professionalEddy Vluggen5-Feb-20 15:09 
GeneralRe: Indexing question Pin
Super Lloyd5-Feb-20 17:38
MemberSuper Lloyd5-Feb-20 17:38 
GeneralRe: Indexing question Pin
Eddy Vluggen6-Feb-20 2:50
professionalEddy Vluggen6-Feb-20 2:50 
AnswerRe: Indexing question Pin
Jörgen Andersson5-Feb-20 22:28
professionalJörgen Andersson5-Feb-20 22:28 
AnswerRe: Indexing question Pin
Richard Deeming6-Feb-20 0:17
mveRichard Deeming6-Feb-20 0:17 
For that query, definitely index 2.

Think of it like searching a massive address book. You're trying to find the highest house number for anyone called "John Smith".
  • Index 1 sorts the addresses by house number, and includes the first and last name. You have to start at the end and scan backwards until you find an entry for "John Smith".
  • Index 2 sorts the addresses by first name, then last name, then house number. You can jump straight to the end of the "John Smith" records, and see the highest house number.




"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Questionintegrity constraint Pin
Tara112-Feb-20 6:23
MemberTara112-Feb-20 6:23 
AnswerRe: integrity constraint Pin
Wendelius2-Feb-20 8:47
mveWendelius2-Feb-20 8:47 
GeneralRe: integrity constraint Pin
Tara112-Feb-20 9:07
MemberTara112-Feb-20 9:07 
GeneralRe: integrity constraint Pin
markkuk2-Feb-20 23:48
Membermarkkuk2-Feb-20 23:48 
Questiontransaction recovery Pin
Tara112-Feb-20 5:46
MemberTara112-Feb-20 5:46 
AnswerRe: transaction recovery Pin
Eddy Vluggen3-Feb-20 3:00
professionalEddy Vluggen3-Feb-20 3:00 
QuestionCopy structure of all the tables of one database to another server Pin
Member 1473192331-Jan-20 4:58
MemberMember 1473192331-Jan-20 4:58 
AnswerRe: Copy structure of all the tables of one database to another server Pin
phil.o31-Jan-20 5:12
mvephil.o31-Jan-20 5:12 
AnswerRe: Copy structure of all the tables of one database to another server Pin
Eddy Vluggen3-Feb-20 3:01
professionalEddy Vluggen3-Feb-20 3:01 
Questionintegrity constraint Pin
Tara1129-Jan-20 10:36
MemberTara1129-Jan-20 10:36 
AnswerRe: integrity constraint Pin
Mycroft Holmes29-Jan-20 10:56
professionalMycroft Holmes29-Jan-20 10:56 
GeneralRe: integrity constraint Pin
Tara1129-Jan-20 11:05
MemberTara1129-Jan-20 11:05 
GeneralRe: integrity constraint Pin
Mycroft Holmes29-Jan-20 11:21
professionalMycroft Holmes29-Jan-20 11:21 
AnswerRe: integrity constraint Pin
Wendelius2-Feb-20 9:01
mveWendelius2-Feb-20 9:01 
QuestionOracle SQL query to MS-SQL Pin
Member 951930620-Jan-20 22:37
MemberMember 951930620-Jan-20 22:37 
AnswerRe: Oracle SQL query to MS-SQL Pin
Richard Deeming21-Jan-20 1:43
mveRichard Deeming21-Jan-20 1:43 
GeneralRe: Oracle SQL query to MS-SQL Pin
Member 951930628-Jan-20 22:44
MemberMember 951930628-Jan-20 22:44 

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.