SQL 2000
In EM, when I click the Database, the right pane shows 3
tabs and under the Tab "Table Info" it shows info on the
table and shows the names of the indexes, but it also
shows names like this with an index grapic next to it:
_WA_sys_Attr_300424B4
What is this? It's not an index that I've created.
Thx,
DonHi Don
No, it's not an index and doesn't take storage space like an index. Is is
just statistics on an unindexed column which can be useful for the optimizer
when coming up with a good plan.
You can read about statistics in the Books Online.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Don" <anonymous@.discussions.microsoft.com> wrote in message
news:03d501c4a02b$049889c0$a401280a@.phx.gbl...
> SQL 2000
> In EM, when I click the Database, the right pane shows 3
> tabs and under the Tab "Table Info" it shows info on the
> table and shows the names of the indexes, but it also
> shows names like this with an index grapic next to it:
> _WA_sys_Attr_300424B4
> What is this? It's not an index that I've created.
> Thx,
> Don
>|||Hi,
These are statistics (name start with _WA) and are not indexes. If
you have auto create statistics on option set for the database and query on
a column that column has no index then sql server will create the statistic
for that column start with the name _WA_SYS_.
Thanks
Hari
MCDBA
"Don" wrote:
> SQL 2000
> In EM, when I click the Database, the right pane shows 3
> tabs and under the Tab "Table Info" it shows info on the
> table and shows the names of the indexes, but it also
> shows names like this with an index grapic next to it:
> _WA_sys_Attr_300424B4
> What is this? It's not an index that I've created.
> Thx,
> Don
>
Showing posts with label indexes. Show all posts
Showing posts with label indexes. Show all posts
Sunday, February 12, 2012
Are these indexes?
SQL 2000
In EM, when I click the Database, the right pane shows 3
tabs and under the Tab "Table Info" it shows info on the
table and shows the names of the indexes, but it also
shows names like this with an index grapic next to it:
_WA_sys_Attr_300424B4
What is this? It's not an index that I've created.
Thx,
Don
Hi Don
No, it's not an index and doesn't take storage space like an index. Is is
just statistics on an unindexed column which can be useful for the optimizer
when coming up with a good plan.
You can read about statistics in the Books Online.
HTH
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Don" <anonymous@.discussions.microsoft.com> wrote in message
news:03d501c4a02b$049889c0$a401280a@.phx.gbl...
> SQL 2000
> In EM, when I click the Database, the right pane shows 3
> tabs and under the Tab "Table Info" it shows info on the
> table and shows the names of the indexes, but it also
> shows names like this with an index grapic next to it:
> _WA_sys_Attr_300424B4
> What is this? It's not an index that I've created.
> Thx,
> Don
>
|||Hi,
These are statistics (name start with _WA) and are not indexes. If
you have auto create statistics on option set for the database and query on
a column that column has no index then sql server will create the statistic
for that column start with the name _WA_SYS_.
Thanks
Hari
MCDBA
"Don" wrote:
> SQL 2000
> In EM, when I click the Database, the right pane shows 3
> tabs and under the Tab "Table Info" it shows info on the
> table and shows the names of the indexes, but it also
> shows names like this with an index grapic next to it:
> _WA_sys_Attr_300424B4
> What is this? It's not an index that I've created.
> Thx,
> Don
>
In EM, when I click the Database, the right pane shows 3
tabs and under the Tab "Table Info" it shows info on the
table and shows the names of the indexes, but it also
shows names like this with an index grapic next to it:
_WA_sys_Attr_300424B4
What is this? It's not an index that I've created.
Thx,
Don
Hi Don
No, it's not an index and doesn't take storage space like an index. Is is
just statistics on an unindexed column which can be useful for the optimizer
when coming up with a good plan.
You can read about statistics in the Books Online.
HTH
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Don" <anonymous@.discussions.microsoft.com> wrote in message
news:03d501c4a02b$049889c0$a401280a@.phx.gbl...
> SQL 2000
> In EM, when I click the Database, the right pane shows 3
> tabs and under the Tab "Table Info" it shows info on the
> table and shows the names of the indexes, but it also
> shows names like this with an index grapic next to it:
> _WA_sys_Attr_300424B4
> What is this? It's not an index that I've created.
> Thx,
> Don
>
|||Hi,
These are statistics (name start with _WA) and are not indexes. If
you have auto create statistics on option set for the database and query on
a column that column has no index then sql server will create the statistic
for that column start with the name _WA_SYS_.
Thanks
Hari
MCDBA
"Don" wrote:
> SQL 2000
> In EM, when I click the Database, the right pane shows 3
> tabs and under the Tab "Table Info" it shows info on the
> table and shows the names of the indexes, but it also
> shows names like this with an index grapic next to it:
> _WA_sys_Attr_300424B4
> What is this? It's not an index that I've created.
> Thx,
> Don
>
Thursday, February 9, 2012
Are the chat transcipts archived anywhere ?
I know there was a technical chat today about indexes.. Are they archived
anywhere ?You can search all the messages at:
http://www.google.com/advanced_group_search?hl=en
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:uUKOBQqkDHA.1708@.TK2MSFTNGP12.phx.gbl...
> I know there was a technical chat today about indexes.. Are they archived
> anywhere ?
>|||I am talking about
http://communities2.microsoft.com/home/chatroom.aspx?siteid=34000015
"I_AM_DON_AND_YOU?" <user@.domain.com> wrote in message
news:eSUZfVqkDHA.1960@.TK2MSFTNGP12.phx.gbl...
> You can search all the messages at:
> http://www.google.com/advanced_group_search?hl=en
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:uUKOBQqkDHA.1708@.TK2MSFTNGP12.phx.gbl...
> > I know there was a technical chat today about indexes.. Are they
archived
> > anywhere ?
> >
> >
>|||Is below what you are looking for?
http://support.microsoft.com/default.aspx?scid=fh;EN-US;pwebcst
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Hassan" <fatima_ja@.hotmail.com> wrote in message news:uUKOBQqkDHA.1708@.TK2MSFTNGP12.phx.gbl...
> I know there was a technical chat today about indexes.. Are they archived
> anywhere ?
>|||Yes, at
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/support/Default.asp?fr=0&sd=tech.
--
Hope this helps,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
Please reply to the newsgroups only, thanks.
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:uUKOBQqkDHA.1708@.TK2MSFTNGP12.phx.gbl...
> I know there was a technical chat today about indexes.. Are they archived
> anywhere ?
>
anywhere ?You can search all the messages at:
http://www.google.com/advanced_group_search?hl=en
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:uUKOBQqkDHA.1708@.TK2MSFTNGP12.phx.gbl...
> I know there was a technical chat today about indexes.. Are they archived
> anywhere ?
>|||I am talking about
http://communities2.microsoft.com/home/chatroom.aspx?siteid=34000015
"I_AM_DON_AND_YOU?" <user@.domain.com> wrote in message
news:eSUZfVqkDHA.1960@.TK2MSFTNGP12.phx.gbl...
> You can search all the messages at:
> http://www.google.com/advanced_group_search?hl=en
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:uUKOBQqkDHA.1708@.TK2MSFTNGP12.phx.gbl...
> > I know there was a technical chat today about indexes.. Are they
archived
> > anywhere ?
> >
> >
>|||Is below what you are looking for?
http://support.microsoft.com/default.aspx?scid=fh;EN-US;pwebcst
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Hassan" <fatima_ja@.hotmail.com> wrote in message news:uUKOBQqkDHA.1708@.TK2MSFTNGP12.phx.gbl...
> I know there was a technical chat today about indexes.. Are they archived
> anywhere ?
>|||Yes, at
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/support/Default.asp?fr=0&sd=tech.
--
Hope this helps,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
Please reply to the newsgroups only, thanks.
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:uUKOBQqkDHA.1708@.TK2MSFTNGP12.phx.gbl...
> I know there was a technical chat today about indexes.. Are they archived
> anywhere ?
>
Are indexed updated?
Dear MSSQL DBAs,
I am trying to research about indexes and find out performance issues
related with indexes. My Questions are :
1) are indexes useful if we are using Bulk operations?
2) does indexes have any effect on simple INSERT or DELETE statements?
3) Do we need to drop indexes before Bulk operations
4) Is individual insert statement in a loop treated as a bulk insertion?
Regards,
Abdul-RahmanFor bulk insert issues, please see the whitepaper below:
[url]http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/incbulkload.mspx[/u
rl]
Indexes do have an effect on DML (insert/update/delete) performance. Any DML
you perform has to be reflected in the non-clustered indexes. For example,
if you have a table with 10 non-clustered indexes and you insert a single
row, a row must be inserted into each non-clustered index. This is called
index maintenance and depending on the way you define the indexes can have a
noticeable effect on performance.
Please let me know if you have any further questions.
Regards
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Abdul-Rahman" <rahman.mahmood@.pk.softecheww.com> wrote in message
news:ev$STuHCFHA.3664@.TK2MSFTNGP14.phx.gbl...
> Dear MSSQL DBAs,
> I am trying to research about indexes and find out performance issues
> related with indexes. My Questions are :
> 1) are indexes useful if we are using Bulk operations?
> 2) does indexes have any effect on simple INSERT or DELETE statements?
> 3) Do we need to drop indexes before Bulk operations
> 4) Is individual insert statement in a loop treated as a bulk insertion?
> Regards,
> Abdul-Rahman
>
I am trying to research about indexes and find out performance issues
related with indexes. My Questions are :
1) are indexes useful if we are using Bulk operations?
2) does indexes have any effect on simple INSERT or DELETE statements?
3) Do we need to drop indexes before Bulk operations
4) Is individual insert statement in a loop treated as a bulk insertion?
Regards,
Abdul-RahmanFor bulk insert issues, please see the whitepaper below:
[url]http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/incbulkload.mspx[/u
rl]
Indexes do have an effect on DML (insert/update/delete) performance. Any DML
you perform has to be reflected in the non-clustered indexes. For example,
if you have a table with 10 non-clustered indexes and you insert a single
row, a row must be inserted into each non-clustered index. This is called
index maintenance and depending on the way you define the indexes can have a
noticeable effect on performance.
Please let me know if you have any further questions.
Regards
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Abdul-Rahman" <rahman.mahmood@.pk.softecheww.com> wrote in message
news:ev$STuHCFHA.3664@.TK2MSFTNGP14.phx.gbl...
> Dear MSSQL DBAs,
> I am trying to research about indexes and find out performance issues
> related with indexes. My Questions are :
> 1) are indexes useful if we are using Bulk operations?
> 2) does indexes have any effect on simple INSERT or DELETE statements?
> 3) Do we need to drop indexes before Bulk operations
> 4) Is individual insert statement in a loop treated as a bulk insertion?
> Regards,
> Abdul-Rahman
>
Subscribe to:
Posts (Atom)