Results 1 to 3 of 3

Thread: Fast output

  1. #1
    Join Date
    Jul 2009
    Posts
    4

    Question Unanswered: Fast output

    hi all

    i want to use the output of the select query in the stored procedure and based on this output of the one field like userId i have to fetch data of the different tables..that i have to done but it takes too long time to get output

    if u have any idea to get fast output?

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by riddhi
    if u have any idea to get fast output?
    make sure that the appropriate columns are properly indexed

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Jul 2009
    Posts
    4

    Question Already Given Index

    i have already Given the index on table structure.

    but when i run this stored procedure in server database that it still take very long time so you have other idea to get the fast output of this stored procedure
    like creating view etc...if yes then how can i fetch result of one select query in to view thats create in stored procedure.

    because based on this select query result set further procedure is proceed.

    Ex select query give the userIds

    and using this userId i have to proceed it means its one kind of input of my stored procedure.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •