Doubts of an Access developer (and SQL Server dummy)

• SQL_dummy-431245

  SSC-Addicted

  Points: 426

  More actions

  May 12, 2009 at 2:59 am

  #209293

  Hi,

  I have a table (140000 records) and i must get info of different "types" and "subtypes":

  In MsAccess I do:

  Query_1= select * from MyTable where X=1111 and T=2222

  Query_2= select * from MyTable where Z=3333

  Query_3= select * from Query_1 where W=9999

  and so on...

  I would like to get the info doing something like:

  getInfo(Type:=1,SubType:=9)

  How is the more efficient way to do it?

  Create a view for every type/subtype and a parametrized sp that selects the view??

  Is faster create a view or embed the SQL in the sp??

• steveb.

  SSC-Forever

  Points: 46733

  More actions

  May 12, 2009 at 3:58 am

  #992716

  I would create a stored proceure for this, to make the query efficent and as fast as possible, uou shoud create the appropriate indexes and not use select * unless you absolutley need the data from all the columns returned