Click here to Skip to main content
15,883,127 members
Home / Discussions / Database
   

Database

 
QuestionUsing the LIKE keyword in a query Pin
reegan4125-Jun-07 5:19
reegan4125-Jun-07 5:19 
AnswerRe: Using the LIKE keyword in a query Pin
Kschuler25-Jun-07 8:47
Kschuler25-Jun-07 8:47 
GeneralRe: Using the LIKE keyword in a query Pin
reegan4125-Jun-07 8:51
reegan4125-Jun-07 8:51 
GeneralRe: Using the LIKE keyword in a query Pin
Kschuler25-Jun-07 9:01
Kschuler25-Jun-07 9:01 
QuestionSQL XML 3 BulkLoad Error Pin
Panchal Hardik25-Jun-07 2:28
Panchal Hardik25-Jun-07 2:28 
AnswerRe: SQL XML 3 BulkLoad Error Pin
Dave Kreskowiak25-Jun-07 4:05
mveDave Kreskowiak25-Jun-07 4:05 
QuestionSQL CE Query Performance Pin
Ferudun Atakan24-Jun-07 22:44
Ferudun Atakan24-Jun-07 22:44 
AnswerRe: SQL CE Query Performance Pin
andyharman24-Jun-07 23:12
professionalandyharman24-Jun-07 23:12 
I don't use SQL CE, but the principles are generally the same for different database products:

Do you have separate indexes on field_b and field_c? If you do then try using a composite index instead:
create index table_b_idx2 on table_b (field_b, field_c, field_d, field_a)

Also, you may be able to get the query to run faster by changing the "select *" bit so that it just returns the columns that you actually need to use.
QuestionSelect unique column??? Pin
Doan Quynh24-Jun-07 22:26
Doan Quynh24-Jun-07 22:26 
AnswerRe: Select unique column??? Pin
Colin Angus Mackay24-Jun-07 22:31
Colin Angus Mackay24-Jun-07 22:31 
GeneralRe: Select unique column??? Pin
Doan Quynh24-Jun-07 22:49
Doan Quynh24-Jun-07 22:49 
GeneralRe: Select unique column??? Pin
Doan Quynh24-Jun-07 22:54
Doan Quynh24-Jun-07 22:54 
GeneralRe: Select unique column??? Pin
Colin Angus Mackay24-Jun-07 23:50
Colin Angus Mackay24-Jun-07 23:50 
Questionyou tried to execute a query that doesn't include the specified expression Pin
nitin324-Jun-07 21:58
nitin324-Jun-07 21:58 
AnswerRe: you tried to execute a query that doesn't include the specified expression Pin
Krish - KP24-Jun-07 22:12
Krish - KP24-Jun-07 22:12 
Questionhelp Pin
nisha thakur24-Jun-07 21:11
nisha thakur24-Jun-07 21:11 
AnswerRe: help Pin
gauthee24-Jun-07 21:13
gauthee24-Jun-07 21:13 
QuestionQuery regarding connecting database Pin
John.L.Ponratnam24-Jun-07 21:03
John.L.Ponratnam24-Jun-07 21:03 
AnswerRe: Query regarding connecting database Pin
rah_sin24-Jun-07 21:10
professionalrah_sin24-Jun-07 21:10 
GeneralRe: Query regarding connecting database Pin
John.L.Ponratnam24-Jun-07 21:30
John.L.Ponratnam24-Jun-07 21:30 
Questiontracing error Pin
mohd imran abdul aziz24-Jun-07 20:26
mohd imran abdul aziz24-Jun-07 20:26 
QuestionViewing Size of a Record Pin
xbiplav24-Jun-07 20:05
xbiplav24-Jun-07 20:05 
AnswerRe: Viewing Size of a Record Pin
andyharman24-Jun-07 22:59
professionalandyharman24-Jun-07 22:59 
QuestionTrigger Manipulation [modified] Pin
M. J. Jaya Chitra24-Jun-07 19:33
M. J. Jaya Chitra24-Jun-07 19:33 
AnswerRe: Trigger Manipulation Pin
Sathesh Sakthivel24-Jun-07 20:04
Sathesh Sakthivel24-Jun-07 20:04 

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.