|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
What does "Build an Index" mean?I was in a job interview recently where they asked me if I had ever "built
an index". What does this mean? Thanks, Siegfried Just guessing here, but I suspect they were looking to see if you had ever
examined the DDL for a table and looked at the tables usage patterns to determine what indexes would be appropriate and, in addition to performing the analysis, physically created/"built" the index using the CREATE INDEX statement. At least that's the type of question I'd be asking during an interview. :) -- Show quote--Brian (Please reply to the newsgroups only.) "Siegfried Heintze" <siegfr***@heintze.com> wrote in message news:eIbcSeyrFHA.1684@TK2MSFTNGP14.phx.gbl... >I was in a job interview recently where they asked me if I had ever "built > an index". > > What does this mean? > > Thanks, > Siegfried > > Is there a tool that will report the usage patterns or does one have to
analyze the perl/VB/C# source code? Thanks, Siegfried Show quote "Brian Lawton" <brian.k.law***@redtailcreek.com> wrote in message news:OmbKNlyrFHA.2596@TK2MSFTNGP09.phx.gbl... > Just guessing here, but I suspect they were looking to see if you had ever > examined the DDL for a table and looked at the tables usage patterns to > determine what indexes would be appropriate and, in addition to performing > the analysis, physically created/"built" the index using the CREATE INDEX > statement. At least that's the type of question I'd be asking during an > interview. :) > > -- > --Brian > (Please reply to the newsgroups only.) > > > "Siegfried Heintze" <siegfr***@heintze.com> wrote in message > news:eIbcSeyrFHA.1684@TK2MSFTNGP14.phx.gbl... > >I was in a job interview recently where they asked me if I had ever "built > > an index". > > > > What does this mean? > > > > Thanks, > > Siegfried > > > > > > Using a combination of SQL Profiler and the Index Tuning Wizard you can get
a good start on the analysis. However in my opinion, no automated tool alone, whether from Microsoft or another 3rd party (and there are several 3rd party tools out there) will outperform a good DBA who understands the business context of the data and how the organization's application interact with it. The tools are just the starting point. -- Show quote--Brian (Please reply to the newsgroups only.) "Siegfried Heintze" <siegfr***@heintze.com> wrote in message news:Om%23kusyrFHA.3444@TK2MSFTNGP12.phx.gbl... > Is there a tool that will report the usage patterns or does one have to > analyze the perl/VB/C# source code? > > Thanks, > Siegfried > > "Brian Lawton" <brian.k.law***@redtailcreek.com> wrote in message > news:OmbKNlyrFHA.2596@TK2MSFTNGP09.phx.gbl... >> Just guessing here, but I suspect they were looking to see if you had >> ever >> examined the DDL for a table and looked at the tables usage patterns to >> determine what indexes would be appropriate and, in addition to >> performing >> the analysis, physically created/"built" the index using the CREATE INDEX >> statement. At least that's the type of question I'd be asking during an >> interview. :) >> >> -- >> --Brian >> (Please reply to the newsgroups only.) >> >> >> "Siegfried Heintze" <siegfr***@heintze.com> wrote in message >> news:eIbcSeyrFHA.1684@TK2MSFTNGP14.phx.gbl... >> >I was in a job interview recently where they asked me if I had ever > "built >> > an index". >> > >> > What does this mean? >> > >> > Thanks, >> > Siegfried >> > >> > >> >> > > In Query Analyzer, you can execute the SQL or stored procedure using the
"Show Execution Plan" option enabled. Amoung other things, this will show you the tables accessed, number of rows returned, whether an index seek or table scan was performed, etc. Show quote "Siegfried Heintze" <siegfr***@heintze.com> wrote in message news:Om%23kusyrFHA.3444@TK2MSFTNGP12.phx.gbl... > Is there a tool that will report the usage patterns or does one have to > analyze the perl/VB/C# source code? > > Thanks, > Siegfried > > "Brian Lawton" <brian.k.law***@redtailcreek.com> wrote in message > news:OmbKNlyrFHA.2596@TK2MSFTNGP09.phx.gbl... >> Just guessing here, but I suspect they were looking to see if you had >> ever >> examined the DDL for a table and looked at the tables usage patterns to >> determine what indexes would be appropriate and, in addition to >> performing >> the analysis, physically created/"built" the index using the CREATE INDEX >> statement. At least that's the type of question I'd be asking during an >> interview. :) >> >> -- >> --Brian >> (Please reply to the newsgroups only.) >> >> >> "Siegfried Heintze" <siegfr***@heintze.com> wrote in message >> news:eIbcSeyrFHA.1684@TK2MSFTNGP14.phx.gbl... >> >I was in a job interview recently where they asked me if I had ever > "built >> > an index". >> > >> > What does this mean? >> > >> > Thanks, >> > Siegfried >> > >> > >> >> > >  |
|||||||||||||||||||||||
Other interesting topics