Post reply

Indexing in SQL Tables

  • July 7, 2008 at 2:45 pm

    #154507

    HI,

    I have a question regarding Indexes..

    What columns should we index in a table?

    What columns should we not index in a table?

    What should be kept in mind for not indexing a cloumn of a table...

    Any help is appreciated...

    Thanks

    [font="Comic Sans MS"]
    ---------------------------------------------------

    Thanks [/font]

  • July 7, 2008 at 6:12 pm

    #839233

    Imndexing is used for Joins, Searches, sorting and filtering and other things.

    If you do all of that -- index, if not -- no point.

    You are in a wrong phorum -- go to general SQL forum or DBA forum.

    Or just read about Indexing in MSSQL (google will help)

    M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM

  • July 7, 2008 at 6:13 pm

    #839234

    I meant if you do ANY of that and you care about performance -- then Mr Index is your man

    M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM

  • July 8, 2008 at 7:21 am

    #839473

    Thanks..

    Well I would also like to know I what case we should not Index a column..

    I mean why Is it said that too much of Indexing is harmful?

    [font="Comic Sans MS"]
    ---------------------------------------------------

    Thanks [/font]

  • July 8, 2008 at 7:54 am

    #839501

    [font="Verdana"]Too much indexing harm on Insert / Update / Delete statments on that table. Because the whole data needs to be rearranged again in case of these statements.

    Mahesh[/font]

    MH-09-AM-8694

  • July 9, 2008 at 10:33 pm

    #840611

    priya (7/8/2008)

    Thanks..

    Well I would also like to know I what case we should not Index a column..

    I mean why Is it said that too much of Indexing is harmful?

    Reading theory about indexing will give you all the answers.

    As I said, you should not index a column if you dont expect to use the index.

    M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply