homepage Welcome to WebmasterWorld Guest from
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

dynamic index
fahad direct

Msg#: 4261103 posted 12:10 pm on Feb 1, 2011 (gmt 0)

I have a table having 55 fields being used as filter. I am not getting how to apply index on the fields. Is there anyway to put a dynamic combinational index to be applied on number of fields used in where clause automatically or should i make one combined index for all values together regardless how many fields are being used in query?



WebmasterWorld Senior Member eelixduppy us a WebmasterWorld Top Contributor of All Time 5+ Year Member

Msg#: 4261103 posted 4:41 am on Mar 9, 2011 (gmt 0)

Sounds like something may be out of place here.

My first question to you is, what percentage of the table do your queries usually return after they execute? If this number is high enough an index will not help you all that much. Secondly, what type of queries are you running here? Reads? Updates? Both? You may also benefit from splitting this table up into smaller, more manageable tables. This really depends on what data this table contains, and how you are going to use it. Only then can you really determine how to make indices to optimize how your queries are going to run.

fahad direct

Msg#: 4261103 posted 11:48 am on Mar 9, 2011 (gmt 0)

Thanks for the reply.

1)About 25%

Global Options:
 top home search open messages active posts  

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved