Professional Web Applications Themes

help for very larg time - Microsoft SQL / MS SQL Server

hi i have a table with 32 fields that 25 fiels of them is varchar we select quary( select * from table) in accses and sql server but the time of select in sqlserver was very larg . please help me with your segastion for decrease this time. thenks for your time....

  1. #1

    Default help for very larg time

    hi
    i have a table with 32 fields that 25 fiels of them is varchar
    we select quary( select * from table) in accses and sql server but the time
    of select in sqlserver was very larg .
    please help me with your segastion for decrease this time.
    thenks for your time.


    nmaco Guest

  2. #2

    Default help for very larg time

    Do you have to return all columns? If so, a clustered
    index may reducce the number of page hits the query may
    take (logical IO's). You can test this by playing with it.

    Run this:

    set statistics io on
    your query

    Look at the logical reads, remember the number

    Put a cluster on on table perform your same query and see
    if the number is lower.

    Of course, if you don't need to return all columns, take
    out that * and specify the columns.

    HTH

    Ray Higdon MCSE, MCDBA, CCNA
    >-----Original Message-----
    >hi
    >i have a table with 32 fields that 25 fiels of them is
    varchar
    >we select quary( select * from table) in accses and sql
    server but the time
    >of select in sqlserver was very larg .
    >please help me with your segastion for decrease this time.
    >thenks for your time.
    >
    >
    >.
    >
    Ray Higdon Guest

Similar Threads

  1. Formatting a time field to 24 hour time (Military time) in the Datagrid
    By David Hearn in forum ASP.NET Data Grid Control
    Replies: 1
    Last Post: September 10th, 02:50 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139