I just did a very simple what I thought should hav...
# orm-help
p
I just did a very simple what I thought should have been a join with SqlServer. I'm surprised to see to sql selects with full table scans. Is there some way to compel or check to see what a join did not happen? This is my prisma code:
Copy code
const data = await context.prisma.News.findMany({
  include: { CodeCampYear: true }
});
Copy code
model News {
  Id                Int          @id(map: "PK__News__3214EC07CA2FD4E0") @default(autoincrement())
  CodeCampYearId    Int
  Visible           Boolean?
  Title             String?      @db.VarChar(256)
  Description       String       @db.VarChar(1024)
  Authors           String       @db.VarChar(256)
  CreatedDate       DateTime     @db.DateTime
  UpdatedDate       DateTime?    @db.DateTime
  ContentData       String?      @db.Text
  UrlExternal       String?      @db.VarChar(512)
  PostDate          DateTime?    @db.DateTime
  YouTubeUrl        String?      @db.VarChar(256)
  AuthorImageUrl    String?      @db.VarChar(256)
  AuthorAttendeesId Int?
  AuthorEmail       String?      @db.VarChar(128)
  YouTubeCode       String?      @db.VarChar(128)
  PictureUrl        String?      @db.VarChar(128)
  CodeCampYear      CodeCampYear @relation(fields: [CodeCampYearId], references: [Id], onUpdate: NoAction, map: "News_fk")

  @@unique([CodeCampYearId, Title], map: "News_uq")
}
Copy code
model CodeCampYear {
  Id                         Int                       @id(map: "PK__CodeCamp__3214EC07BF12A5BA")
  Name                       String                    @db.VarChar(128)
  ...
  VolunteerJob               VolunteerJob[]
}
and the generated sql logged SELECT [ dbo ].[ CodeCampYear ].[ Id ], [ dbo ].[ CodeCampYear ].[ Name ], [ dbo ].[ CodeCampYear ].[ CampStartDate ], [ dbo ].[ CodeCampYear ].[ CampEndDate ], [ dbo ].[ CodeCampYear ].[ CodeCampDateString ], [ dbo ].[ CodeCampYear ].[ CodeCampSaturdayString ], [ dbo ].[ CodeCampYear ].[ CodeCampSundayString ], [ dbo ].[ CodeCampYear ].[ HostName ], [ dbo ].[ CodeCampYear ].[ BaseUrl ], [ dbo ].[ CodeCampYear ].[ UrlPostToken ], [ dbo ].[ CodeCampYear ].[ TagLine ], [ dbo ].[ CodeCampYear ].[ CodeCampYearTypeId ], [ dbo ].[ CodeCampYear ].[ EmailFooterImage ], [ dbo ].[ CodeCampYear ].[ EmailHeaderImage ], [ dbo ].[ CodeCampYear ].[ EmailBgImage ], [ dbo ].[ CodeCampYear ].[ EmailAdLinkUrl ], [ dbo ].[ CodeCampYear ].[ EmailAdLinkImage ], [ dbo ].[ CodeCampYear ].[ EmailAdLinkImageMarginTop ], [ dbo ].[ CodeCampYear ].[ EmailAdLinkImageWidth ], [ dbo ].[ CodeCampYear ].[ MeetupDetailsRequiredWord1 ], [ dbo ].[ CodeCampYear ].[ MeetupDetailsRequiredWord2 ], [ dbo ].[ CodeCampYear ].[ MeetupReferralUrl ], [ dbo ].[ CodeCampYear ].[ MeetupGroupReferralImage ], [ dbo ].[ CodeCampYear ].[ MeetupReferralText ], [ dbo ].[ CodeCampYear ].[ SiteLocked ], [ dbo ].[ CodeCampYear ].[ NgUrlDefault ], [ dbo ].[ CodeCampYear ].[ LiveStreamFeedOverride ], [ dbo ].[ CodeCampYear ].[ ShowLiveFeedStart ], [ dbo ].[ CodeCampYear ].[ ShowLiveFeedEnd ], [ dbo ].[ CodeCampYear ].[ LiveFeedEmbedCode ], [ dbo ].[ CodeCampYear ].[ LiveFeedEmbedCodeEmpty ], [ dbo ].[ CodeCampYear ].[ LiveFeedTitle ], [ dbo ].[ CodeCampYear ].[ LiveFeedTrackId ], [ dbo ].[ CodeCampYear ].[ LiveFeedSponsorNameDefault ], [ dbo ].[ CodeCampYear ].[ LiveFeedSponsorUrlDefault ], [ dbo ].[ CodeCampYear ].[ LiveFeedCurrentSessionId ], [ dbo ].[ CodeCampYear ].[ Address ], [ dbo ].[ CodeCampYear ].[ City ], [ dbo ].[ CodeCampYear ].[ State ], [ dbo ].[ CodeCampYear ].[ Zipcode ], [ dbo ].[ CodeCampYear ].[ LocationName ], [ dbo ].[ CodeCampYear ].[ HackathonDateString ], [ dbo ].[ CodeCampYear ].[ HackathonLocation ], [ dbo ].[ CodeCampYear ].[ HackathonLocationUrl ] FROM [ dbo ].[ CodeCampYear ] WHERE 1 = 1 [] Query CodeCampYear.findMany took 792ms SELECT 1 [] SELECT [ dbo ].[ News ].[ Id ], [ dbo ].[ News ].[ CodeCampYearId ], [ dbo ].[ News ].[ Visible ], [ dbo ].[ News ].[ Title ], [ dbo ].[ News ].[ Description ], [ dbo ].[ News ].[ Authors ], [ dbo ].[ News ].[ CreatedDate ], [ dbo ].[ News ].[ UpdatedDate ], [ dbo ].[ News ].[ ContentData ], [ dbo ].[ News ].[ UrlExternal ], [ dbo ].[ News ].[ PostDate ], [ dbo ].[ News ].[ YouTubeUrl ], [ dbo ].[ News ].[ AuthorImageUrl ], [ dbo ].[ News ].[ AuthorAttendeesId ], [ dbo ].[ News ].[ AuthorEmail ], [ dbo ].[ News ].[ YouTubeCode ], [ dbo ].[ News ].[ PictureUrl ] FROM [ dbo ].[ News ] WHERE 1 = 1 [] Query News.findMany took 556ms