alert:Queryonunindexedcolumn

11 views
Skip to first unread message

pashtetkun

unread,
Mar 27, 2015, 5:01:18 AM3/27/15
to nhp...@googlegroups.com
I have legacy database and simple query:

SELECT webshop0_.ID                  as ID85_0_,
       webshop0_.NAME                as NAME85_0_,
FROM   SITES webshop0_
WHERE  webshop0_.ID = '48e0a097-e897-4abd-8b98-2b3ffc6c405b'

ID is PRIMARY KEY. NHprof raise this alert. Why?
My model and fluent mapping:

public class WebShop
{
        public virtual Guid Id { get; protected set; }
        public virtual string Name { get; set; }
}

public class WebShopMap : ClassMap<WebShop>
 {    
        public WebShopMap()
        {
            Table("SITES");
            Id(x => x.Id).Column("ID").GeneratedBy.GuidComb();
            Map(x => x.Name).Column("NAME");
        }
}



Fitzchak Yitzchaki

unread,
Mar 29, 2015, 2:37:04 AM3/29/15
to nhp...@googlegroups.com
This is a duplicated, discussed in a different thread

Best Regards,

Hibernating Rhinos Ltd  cid:image001.png@01CF95E2.8ED1B7D0

Fitzchak Yitzchaki l Senior Software Engineer Mobile:+972-58-345-9538


--
You received this message because you are subscribed to the Google Groups "nhprof" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nhprof+un...@googlegroups.com.
To post to this group, send email to nhp...@googlegroups.com.
Visit this group at http://groups.google.com/group/nhprof.
For more options, visit https://groups.google.com/d/optout.

Reply all
Reply to author
Forward
0 new messages