Click here to Skip to main content
15,877,280 members
Home / Discussions / Database
   

Database

 
PinnedHOW TO ANSWER A QUESTION PinPopular
Chris Maunder16-Jul-09 3:10
cofounderChris Maunder16-Jul-09 3:10 
PinnedHow to get an answer to your question PinPopular
Chris Maunder10-Nov-05 16:30
cofounderChris Maunder10-Nov-05 16:30 
QuestionRun an external program C# from within the Oracle Developer Pin
Member 162354202-Apr-24 10:37
Member 162354202-Apr-24 10:37 
AnswerRe: Run an external program C# from within the Oracle Developer Pin
jschell2-Apr-24 14:18
jschell2-Apr-24 14:18 
QuestionDisplay records based on selected date range in months within same year? Pin
samflex21-Jan-24 9:28
samflex21-Jan-24 9:28 
AnswerRe: Display records based on selected date range in months within same year? Pin
jschell22-Jan-24 5:50
jschell22-Jan-24 5:50 
GeneralRe: Display records based on selected date range in months within same year? Pin
samflex22-Jan-24 8:35
samflex22-Jan-24 8:35 
GeneralRe: Display records based on selected date range in months within same year? Pin
Victor Nijegorodov22-Jan-24 10:10
Victor Nijegorodov22-Jan-24 10:10 
GeneralRe: Display records based on selected date range in months within same year? Pin
Richard MacCutchan22-Jan-24 21:47
mveRichard MacCutchan22-Jan-24 21:47 
GeneralRe: Display records based on selected date range in months within same year? Pin
samflex23-Jan-24 13:44
samflex23-Jan-24 13:44 
GeneralRe: Display records based on selected date range in months within same year? Pin
jschell23-Jan-24 5:55
jschell23-Jan-24 5:55 
Questiontime-consuming insert operation Pin
mike741118-Jan-24 16:25
mike741118-Jan-24 16:25 
AnswerRe: time-consuming insert operation Pin
Eddy Vluggen18-Jan-24 16:41
professionalEddy Vluggen18-Jan-24 16:41 
AnswerRe: time-consuming insert operation Pin
jschell19-Jan-24 4:40
jschell19-Jan-24 4:40 
QuestionCREATE INDEX Pin
mike741117-Jan-24 17:22
mike741117-Jan-24 17:22 
I was looking at the documentation for CREATE INDEX in SQL:

https://www.w3schools.com/sql/sql_create_index.asp

SQL
CREATE INDEX index_name
ON table_name (column1, column2, ...);

I don't understand when you would create it for multiple columns. Let's say you did this:

SQL
CREATE INDEX idx_pname ON Persons (LastName, FirstName);

Does that create one index on two columns? Or, is that the same as creating two indexes?

For instance, does that statement create two hashtables? Or one hashtable?

Thank you.
AnswerRe: CREATE INDEX Pin
Victor Nijegorodov17-Jan-24 20:37
Victor Nijegorodov17-Jan-24 20:37 
AnswerRe: CREATE INDEX Pin
jschell18-Jan-24 4:44
jschell18-Jan-24 4:44 
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 

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.