Click here to Skip to main content
15,883,558 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 
QuestionLooking for a Better Database Solution for Trading Systems Pin
Rene Rose 202120-Apr-24 5:53
Rene Rose 202120-Apr-24 5:53 
AnswerRe: Looking for a Better Database Solution for Trading Systems Pin
Jeremy Falcon20-Apr-24 8:15
professionalJeremy Falcon20-Apr-24 8:15 
AnswerRe: Looking for a Better Database Solution for Trading Systems Pin
RedDk20-Apr-24 8:33
RedDk20-Apr-24 8:33 
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 
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 
In data base talk it is known as a 'table scan'.

Most databases have a way which allows you to see what it is doing. Oracle, SQL Server and MySQL IDEs all have a way to see this clearly. The nomenclature used in the output is hard to read but practice makes that easier.

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.