Regardless of how many rows of data there may be that match my selection criteria I only want one so my application knows that "Yes, there is data there that matches the selection criteria". I may or may not choose to bring in the entire result set based on other logic. My application is an interactive display and fast response times are essential.
Does anyone have any suggestions on how I can accomplish this or can you offer help around how I can do a quick existence check of data without going through the expense of bringing in the entire result set?
Is there a technique for doing this?
Of course my assumption is that because I'm returning only one record this operation will be extremely fast but I don't know (I'm a rookie so pardon me if this is a really dumb question).
Any help would be greatly appreciated.
Does anyone have any suggestions on how I can accomplish this or can you offer help around how I can do a quick existence check of data without going through the expense of bringing in the entire result set?
Is there a technique for doing this?
Of course my assumption is that because I'm returning only one record this operation will be extremely fast but I don't know (I'm a rookie so pardon me if this is a really dumb question).
Any help would be greatly appreciated.