Searching on Multiple Tables

• Teemo

  Ten Centuries

  Points: 1376

  More actions

  October 28, 2010 at 2:42 am

  #228449

  Hi,

  I know that many sql developer here can give me clarification on this matter.

  What I want to know is that,

  For example I want to search these strings(ex. 'Asanti','Goodyear','Cadillac'), And i want every string to search on 1 to 3 tables with 10Million rows each.

  Is it possible to use Full Text Search in searching to multiple tables?

  Or is there other way on doing this type of search?

  Thanks in advance

  Vincent

• Jeff Moden

  SSC Guru

  Points: 1000539

  More actions

  October 28, 2010 at 2:54 am

  #1243393

  InfiniteError (10/28/2010)

  ---

  Hi,

  I know that many sql developer here can give me clarification on this matter.

  What I want to know is that,

  For example I want to search these strings(ex. 'Asanti','Goodyear','Cadillac'), And i want every string to search on 1 to 3 tables with 10Million rows each.

  Is it possible to use Full Text Search in searching to multiple tables?

  Or is there other way on doing this type of search?

  Thanks in advance

  Vincent

  Whether you use Full Text Search or not, you're only going to be able to search one table at a time. And, I suspect that you don't need Full Text Search for this but I don't know any of your other requirements nor what your table schema is nor what any of your data looks like. Some of that information would be very helpful to others in giving you a more complete answer.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
  "Change is inevitable... change for the better is not".
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)
  Intro to Tally Tables and Functions